You are currently reviewing an older revision of this page.
How do I sort a flextable (such as pipe or conduit) in order of upstream to downstream?
By default, element flextables are ordered by their element ID, which is based on the order that they were drawn or inserted into the model. Sometimes it is necessary to view a flextable in a different order such as upstream-downstrean, not by ID or label. Our storm and sewer products have an ability to do so because the flow is always in the same direction. However our water modeling products can have flow in either direction, so the situation is different.
Right click any column header and choose either "Sort Upstream->Downstream" or "Sort Downstream->Upstream".
Right click in the drawing plan view, choose "Edit Group", then double click the pipe table
Ensure that the Hydraulic grade (start) or Hydraulic Grade (stop) field is added to the table
Right click the HGL start or stop field and choose either Ascending or Descending, depending if you want to sort upstream or downstream. This of course assumes that you have at least some flow in the pipes you're sorting, so as to have a decrease in HGL as you move downstream.
Note: If you want complete control over order, you could add a numeric User Data Extension field, add that column to your FlexTable, enter a value to specify the order for each row, then sort by that field.