Skip to main content
Solved

ArcGIS - How to update related table without creation duplicate record.


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.
View original
Did this help you find an answer to your question?

fmelizard
Contributor
Forum|alt.badge.img+16
  • Contributor
  • November 27, 2017
Hi @adnan_abbasi, are you able to provide any images or samples of the input datasets?

 


Greetings & Thanks for your replay,

Please find attached image.


redgeographics
Celebrity
Forum|alt.badge.img+45

Maybe 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.


fmelizard
Contributor
Forum|alt.badge.img+16
  • Contributor
  • December 12, 2017

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.

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings