Skip to main content
Question

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

  • April 25, 2018
  • 3 replies
  • 185 views
O

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

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.

3 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • 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

Partner Solutial Brazil - www.solutial.com.br
O
  • obrienor
  • Author
  • 1 reply
  • April 25, 2018

hI @danilo_fme

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

Loving FME

Thanks

James

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • April 25, 2018

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!

 

 

Partner Solutial Brazil - www.solutial.com.br

Community Stats

32,087
Posts
121,852
Replies
39,729
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.