Question

How to merge multiple records but create a list from one attribute?

  • 6 December 2018
  • 4 replies
  • 41 views

Badge

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


4 replies

Badge +2

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.

attributecombiner.fmw

Userlevel 2
Badge +12

The Aggregator transformer could do this (Group by InspectionId, Attribute to concatenate FeatureId):

Badge

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?

Badge +10

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