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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+2- Contributor
- 606 replies
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.
+22- Contributor
- 2179 replies
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?
+44- Influencer
- 3422 replies
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.