Skip to main content
Question

Merging Values of Two Columns which have more than one match into one column


I have a CSV file showing Bus Stop Codes in one column and Bus Route Numbers in another column.

As you can see there are multiple Bus Stop Codes for each Route..

I want to create a table which shows the following

I am very new to FME and only learning the basics. Is there an easy way to do this in FME for all the Bus Stop Codes ??

I've attached an example CSV file

James

3 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • April 25, 2018

Hi @obrienor

You can use the transformer Aggregator like this image:

Configurations - Group By: Bus_Stop_Code and Attributes to Concatenate = Route

Thanks,

Danilo


  • Author
  • April 25, 2018

hI @danilo_fme

This worked so well... thank you so much for your help.

Loving FME

Thanks

James


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • April 25, 2018
obrienor wrote:

hI @danilo_fme

This worked so well... thank you so much for your help.

Loving FME

Thanks

James

Excellent news James. I'm happy to help you!

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings