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
+2- Contributor
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.
+17- Contributor
The Aggregator transformer could do this (Group by InspectionId, Attribute to concatenate FeatureId):
erik_jan wrote:
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?
+33- Influencer
mariofederis wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.