Conditional textjoin in Dataiku help

[yueykabuey]

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) 

[Turribeach · Accepted solution]

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

[yueykabuey]

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

[Turribeach]

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

[Turribeach]

And please mark the thread as acepted solution 😉

[Turribeach]

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

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.