This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Junction flextable

In my pipe flextable i see what junctions are connected to each pipe. If I copy the junctions connected to a group of pipes in the pipe flextable, is there a away that I can use the  data I copied to filter in the junction felxtable. I can not use the the NOT Like method because I would have to enter he code for each copied junction and the junctions are simply to many for me to do that. 

Parents
  • I think might be able to use excel to right the NOT LIKE query for all the copied nodes. Just thought of that. But is there an easier way?

  • Hi Christen,

    There is an "IN" operator that may work for you (which takes a comma delimited list).

    Label in ('J-1', 'J-2', 'J-3', 'J-4', 'J-5', 'J-6', 'J-7')

    Another possible way to go:

    1. Filter your pipe flextable to the results you are interested in
      1. Click the "Select in Drawing" toolbar button
    2. Open View > Queries
      1. Under "Network Trace" choose "Find Adjacent Nodes"
    3. Open the Junction table on that selection.
      1. There are a few different ways to open a table on a selection (e.g. right-click Edit Group).

    Rob.

    Answer Verified By: Christen Crique 

Reply
  • Hi Christen,

    There is an "IN" operator that may work for you (which takes a comma delimited list).

    Label in ('J-1', 'J-2', 'J-3', 'J-4', 'J-5', 'J-6', 'J-7')

    Another possible way to go:

    1. Filter your pipe flextable to the results you are interested in
      1. Click the "Select in Drawing" toolbar button
    2. Open View > Queries
      1. Under "Network Trace" choose "Find Adjacent Nodes"
    3. Open the Junction table on that selection.
      1. There are a few different ways to open a table on a selection (e.g. right-click Edit Group).

    Rob.

    Answer Verified By: Christen Crique 

Children
No Data