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

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

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.

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