Skip to main content
Solved

Group column A, merge column B

  • November 27, 2025
  • 4 replies
  • 30 views

scootercat_nl
Contributor
Forum|alt.badge.img+6
A caseA column code contains both unique and identical values ​​(e.g., A, A, B, C, C, C, D, E, E).A second column names contains different names.I want to group a column, but the names associated with it need to be merged.How can I easily solve this in FME?

 

Thanks in advanced!

Best answer by alexbiz

The aggregator should do the trick.
You can group by any attribute, in your case “code”, and concatenate the attribute you want, “name”

4 replies

alexbiz
Influencer
Forum|alt.badge.img+30
  • Influencer
  • November 27, 2025

Hey, do you have example datasets of what you have and what you want as a result ?


scootercat_nl
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • November 27, 2025

See my example Excel File. 

 

In reality I obviously have different data, but the idea is the same.


alexbiz
Influencer
Forum|alt.badge.img+30
  • Influencer
  • Best Answer
  • November 27, 2025

The aggregator should do the trick.
You can group by any attribute, in your case “code”, and concatenate the attribute you want, “name”


scootercat_nl
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • November 27, 2025

It can be that simple, right?

 

Thank you very much for your response.