CONCAT COLUMN IN SPECIFIC ORDER

[cinthy]

Hi,

I need to concatenate the INFO column per ARTIKEL depending on the number in column SEQ.
I’ve tried GROUPBY and did a concat for SEQ, 5,10,15,…
But I don’t know how I can concat the INFO in the correct order.

Can someone help me fix my problem?

Cinthy

[takbb]

Hi @cinthy , if I understand your question correctly, use Row Sorter to first sort you rows by SEQ and then perform the Group By, grouping on ARTIKEL, and concatenating INFO, but make sure you have “retain row order” selected on the Group By node

[cinthy]

Thanks,
The checkbox was indeed the answer to my problem.

[takbb]

Hi @cinthy , glad to hear your problem is resolved.