Question

Concatenate multiple records

+3

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

+21

Use an Aggregator to combine all features into one feature.

+3

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

Sign up