Customizing flex table for pipe in Water gems

Hello Prash,

You can use the "Edit" tool in the Pipe Flextable to add required fields.

Here is a relevant article which explains this in details;

Customizing FlexTables for viewing and reporting data -- Moving, adding, and removing columns

Hope this helps.

Yes but the fact is that i want column of Elevation for Start Node and Elevation for End Node in flex table of pipe. These information is related to junction and easily appears in junction table but i want this in flex table of PIPE. For moving and adding this field is not available for pipe.  

Hello Prash,

To get the elevation you would have to define a User Defined Extension (UDX) to capture the junction elevations. You can try this approach;

1. Define a formula based UDX for Start Node Elevation. Keep the Data Type as "Real (Formula)" Dimension as "Length", Storage Unit as "m" and Numeric Formatter as "Elevation".

2. In the Formula use this formula "Hydraulic Grade (Start) - Pressure (Start)". You can directly copy and paste the following formula;

[IdahoPipeResults_PipeStartHgl; Meters]- [IdahoPipeResults_PipeStartPressure; MetersOfH2O]

Note that I have kept the units of Pressure as "m of H2O"

3. Now add the column as per before article to get the start node elevation.

4. Similarly create a new formula based UDX for Stop Node Elevation.  But the formula in this case should be "Hydraulic Grade (Stop) - Pressure (Stop)"

You can directly copy and paste the below formula;

[IdahoPipeResults_PipeStopHgl; Meters]- [IdahoPipeResults_PipeStopPressure; MetersOfH2O]

5. Add this column also.

This will give you the elevation of the start and stop nodes in the pipe flextable.

However, you must maintain the display precision the same for all the parameters involved.

Hope this helps.

Thank you .

This is nice solution, but if we compare the Start Node elevation with the elevation in junction table. There is difference between both elevation. I need the exact value which we have given in Elevation at junction table.