Skip to main content
Question

Concatenate multiple records

fme_hans
Contributor
Forum|alt.badge.img+5

Hi,

In an Excel file, the data of 1 object is spread over several lines. This looks like this:

ColumnA ColumnB ColumnC

 

item 1

 

data item 2

 

data item 3

 

How can I ensure that all data is on one line? like this:

ColumnA ColumnB ColumnC

 

item 1 item 2 item 3

 

Greatings, Hans

2 replies

sigtill
Supporter
Forum|alt.badge.img+24
  • sigtillSupporter
  • Supporter
  • July 3, 2020

Use an Aggregator to combine all features into one feature.

The real SigTill
fme_hans
Contributor
Forum|alt.badge.img+5
  • fme_hansContributor
  • Author
  • Contributor
  • July 6, 2020
Hi,

I hadn't thought about the aggregator. Set Group by to the right attribute and the accumulation to merge incoming attributes and it works.

 

Thanks

 

 

Reply


Helpful Members This Week

Community Stats

31,336
Posts
118,868
Replies
38,958
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.