Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

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

Solved!
prabhakaran808
Level 2
how to concat several rows and create one value in a new column separated by comma

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 IDContract name
M11AA
M11BB
M11CC
M21DD
M21EE
M21FF
M31GG
M31HH

 

I would like to achieve the output like below.

Contract IDContract name
M11AA;BB;CC
M21DD;EE;FF
M31GG;HH

 

Can this be achieved in Dataiku? 


Operating system used: windows

0 Kudos
2 Solutions
AlexT
Dataiker

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 , 
Screenshot 2023-01-26 at 09.32.03.png

 

Thanks

View solution in original post

prabhakaran808
Level 2
Author

Thanks Alex. It works 🙂

View solution in original post

2 Replies
AlexT
Dataiker

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 , 
Screenshot 2023-01-26 at 09.32.03.png

 

Thanks

prabhakaran808
Level 2
Author

Thanks Alex. It works 🙂