how to concat several rows and create one value in a new column separated by comma

[prabhakaran808]

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

[AlexT · Accepted solution]

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

[AlexT · Accepted solution]

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

[prabhakaran808 · Accepted solution]

Thanks Alex. It works 🙂