Conditional textjoin in Dataiku help

Solved!
yueykabuey
Level 1
Conditional textjoin in Dataiku help

Hi all, I am trying to 'textjoin' in Dataiku, whereby I would like to concatenate all values in Column B (condition type) based on the value in column A (deal id), so I get the output below (highlighted yellow column) 

Screenshot 2024-03-08 at 10.30.51.png

0 Kudos
1 Solution
Turribeach

A Group By recipe with concat on the column will give you the string concatenation:

Screenshot 2024-03-08 at 11.08.52.png

Screenshot 2024-03-08 at 11.10.07.png

View solution in original post

5 Replies
Turribeach

A Group By recipe with concat on the column will give you the string concatenation:

Screenshot 2024-03-08 at 11.08.52.png

Screenshot 2024-03-08 at 11.10.07.png

yueykabuey
Level 1
Author

That was exactly what I was after, thank you so much! Spent quite a few hours trying to find a solution!!

0 Kudos

Also see below for a solution that doesn't group the rows.

0 Kudos

And please mark the thread as acepted solution 😉

0 Kudos
Turribeach

Or if you prefer to keep the rows ungrouped you can use a Window recipe with a custom aggregation:

Screenshot 2024-03-08 at 11.19.11.png

Screenshot 2024-03-08 at 11.19.17.pngScreenshot 2024-03-08 at 11.19.29.png

PS: Custom Aggregations are not supported in the DSS engine so make sure you have your datasets in a SQL database that supports string_agg aggregate function or consult with your database documentation on what function you can use.

0 Kudos