Skip to main content
Question

How to combine values from multiple records into one?

  • July 11, 2018
  • 4 replies
  • 214 views
E
Forum|alt.badge.img

Good morning FME ninjas,

I've used a ListExploder to get some opening hours - I'm now having below problem:

Per record the opening hours for each day are written in a separate line.

 

I'd like to have all values in one line. How would I bring this data together?

Thanks,

 

Eduard

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.

4 replies

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • July 11, 2018

Hi @edhere, try using the Aggregator with these parameters

  • Group By: POI_NAME
  • Accumulation Mode: Merge Incoming Attributes
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • July 11, 2018

Hi @edhere, try using the Aggregator with these parameters

  • Group By: POI_NAME
  • Accumulation Mode: Merge Incoming Attributes
[Addition] If the blank cells have <null> or empty string, remove them (i.e. change them to <missing>) with the NullAttributeMapper beforehand.

 

 

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
E
Forum|alt.badge.img
  • edhere
  • Author
  • 60 replies
  • July 11, 2018

Hi @edhere, try using the Aggregator with these parameters

  • Group By: POI_NAME
  • Accumulation Mode: Merge Incoming Attributes
You deserve a statue @takashi.

 

F
Forum|alt.badge.img
[Addition] If the blank cells have <null> or empty string, remove them (i.e. change them to <missing>) with the NullAttributeMapper beforehand.

 

 

Thanks Takashi!

Community Stats

32,080
Posts
121,820
Replies
39,714
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.