Concatenating the values of a third column in a cell

[hmd_pouya]

Hi,

I need to put the values of a third column together with a delimiter “,” based on unique values of two other columns. For example, given the following table

col1 | col2 | col3
1 | 1 | 3
1 | 2 | 4
1 | 1 | 5
2 | 3 | 6

and the result should be
col1 | col2 | col3
1 | 1 | 3,5
1 | 2 | 4
2 | 3 | 6

Thanks in advance for any suggestions.

[Andrew_Steel]

Hi @hmd_pouya,

you could use the GroupBy Node. col1 and col2 as Group Columns and a Manual Aggregation with Concatenate for col3. Set Value Delimiter to “,”

I hope it helps.

Best regards
Andrew

[hmd_pouya]

Thanks @Andrew_Steel . It worked.