Skip to main content
Question

Concatenate multiple records

  • July 3, 2020
  • 2 replies
  • 6 views
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

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.

2 replies

sigtill
Supporter
Forum|alt.badge.img+25
  • sigtillSupporter
  • Supporter
  • 956 replies
  • 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
  • 44 replies
  • 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

 

 

Community Stats

32,071
Posts
121,786
Replies
39,700
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.