Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I would like to Concat a set of rows in to one value in a column separated by comma or colon. Example as below.
My Dataset,
Contract ID | Contract name |
M11 | AA |
M11 | BB |
M11 | CC |
M21 | DD |
M21 | EE |
M21 | FF |
M31 | GG |
M31 | HH |
I would like to achieve the output like below.
Contract ID | Contract name |
M11 | AA;BB;CC |
M21 | DD;EE;FF |
M31 | GG;HH |
Can this be achieved in Dataiku?
Operating system used: windows
Hi @prabhakaran808 ,
You can use the Group recipe. https://knowledge.dataiku.com/latest/courses/basics/group-data/group-data-summary.html
For the column you want to contact select "concat" and the separator e.g ; or ,
Thanks
Thanks Alex. It works ๐
Hi @prabhakaran808 ,
You can use the Group recipe. https://knowledge.dataiku.com/latest/courses/basics/group-data/group-data-summary.html
For the column you want to contact select "concat" and the separator e.g ; or ,
Thanks
Thanks Alex. It works ๐