UnderGroundCable and OverheadTransmissionLine Line are two feature classes. some part of circuit A-B is UGC and and some is OHTL.
Both feature classes are related with the Electric Line Table.
In the ElectricLine table should be one record with the Circuitname= A-B and other common attributes and length should be UGC=OHTL .
Relation is one to many by CircutName field.
how i can do this by FME without creation duplicate record.
Thanks & Regards, AZA
Best answer by fmelizard
Hi @adnan_abbasi, just as @redgeographics mentioned, the StatisticsCalculator can be used here. You connect the CircuitSection table to the transformer. Inside, you'll have to group by the CircuitName, and set the Attributes to Analyze to the Length attribute. You can delete most of the values for the Calculate Attributes: leave the sum to calculate the total length and leave the Numeric Count or Total Count if you wanted to get the total number of sections that were added up.
Alternatively, the Aggregator will also work. Group by CircuitName, set a Count attribute if needed, and set the Length as the Attributes to Sum. Here, you have the option of creating a list of the Environment values if you wanted.
+20
+60Maybe I'm missing something, but isn't it just a selection of the OH sections from the CircuitSection table into the ElectricLine table? If there's multiple sections of OH on a single circuit you could use the StatisticsCalculator to sum the lengths and output a single record per circuit.
+20Hi @adnan_abbasi, just as @redgeographics mentioned, the StatisticsCalculator can be used here. You connect the CircuitSection table to the transformer. Inside, you'll have to group by the CircuitName, and set the Attributes to Analyze to the Length attribute. You can delete most of the values for the Calculate Attributes: leave the sum to calculate the total length and leave the Numeric Count or Total Count if you wanted to get the total number of sections that were added up.
Alternatively, the Aggregator will also work. Group by CircuitName, set a Count attribute if needed, and set the Length as the Attributes to Sum. Here, you have the option of creating a list of the Environment values if you wanted.
