Hello guys, I have a very long water distribution network imported via model builder from a GIS-based data.My questions are;-

1. Is there a way to create a new column on the "pipe" flex table to show the cumulative length of the length of pipes available?Its quite tiresome to input certain varying parameters like the size/type of pipes along the total length of pipe at certain specified distances(Let us say in 3000m, the pipe diameter varies as follows,1200m=16",800m=12" then the rest 1000m=8").How can I easily achieve this?Creating a flex table cumulative column looks like the best method for me.

You can also assist by defining a new user data extension.

2. On a dense network model or a branched /T-network, how can I easily sort my HGL from upstream to downstream along one branch then finish up with HGL data from the junction to the 2nd branch lets say on a T-network.(R1 to J 1,then J1 to node 1 and J 1 to node 2: How can I sort my HGL data on the flex table from upstream to downstream from R 1 to node 1 through J 1 then the rest of the network HGL data from J 1 to node 2 to follow right below.