Skip to main content
  • EN

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

Hi @edhere, try using the Aggregator with these parameters

  • Group By: POI_NAME
  • Accumulation Mode: Merge Incoming Attributes

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.

 

 

Hi @edhere, try using the Aggregator with these parameters

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

 

[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


Community Stats

31,756
Posts
120,637
Replies
39,380
Members

Latest FME

Terms & ConditionsCookie 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.