Combine rows with a separator

[sid3011]

Hi all,

Need a help in concatenation of rows with similar key. For example:

Input:
ABC 1 
ABC 2
DEF 3
DEF 4

Output:
ABC 1,2
DEF 3,4

Regards,
Siddharth

[ebarre1 · Accepted solution]

Hi @sid3011

Use the shape operation to group by the key and an array aggregate operation.