Skip to main content
Question

How to combine values from multiple records into one?

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

4 replies

takashi
Influencer
  • takashiInfluencer
  • July 11, 2018

Hi @edhere, try using the Aggregator with these parameters

  • Group By: POI_NAME
  • Accumulation Mode: Merge Incoming Attributes
takashi
Influencer
  • takashiInfluencer
  • July 11, 2018
takashi wrote:

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.

 

 

E
Forum|alt.badge.img
  • edhere
  • Author
  • July 11, 2018
takashi wrote:

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
takashi wrote:
[Addition] If the blank cells have <null> or empty string, remove them (i.e. change them to <missing>) with the NullAttributeMapper beforehand.

 

 

Thanks Takashi!

Reply


Helpful Members This Week

Community Stats

31,344
Posts
118,867
Replies
38,934
Members

Latest FME

Terms & ConditionsCookie settings

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
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.