Row aggregation

I have a table like this
image

I want to aggregate the location records and create a table at ID level.
image

I read about Row aggregator node, but that is not available below version 5, I’m using 4.6.

If there is any other way, please suggest.

Braveen

Hi @Braveen you can use the -GroupBy- node, grouping by Id column and selecting concatenate as the aggregation method for the location column

Best wishes
Heather

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.