I have 2 records with identical attribute values except for one field (FeatureID). How can I merge the records but create a list from the FeatureID.
The result should be highlighted on the attached picture
Page 1 / 1
Hi @mariofederis,
Have you tried using the AttributeCombiner available on the FME Hub? This transformer will allow you to group by InspectionID, combine by FeatureID, and choose the delimiter string.
The Aggregator transformer could do this (Group by InspectionId, Attribute to concatenate FeatureId):
The Aggregator transformer could do this (Group by InspectionId, Attribute to concatenate FeatureId):
Thanks for the recommendation Erik.
On the same note, my workflow requires me to regain those two features later down the road. How do you recommend I explode them from that 1 record?
Thanks for the recommendation Erik.
On the same note, my workflow requires me to regain those two features later down the road. How do you recommend I explode them from that 1 record?
If you generate a list in the aggregator with the InspectionID and the Description you'll be able to explode that list to regain the two features.