Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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)โ
A Group By recipe with concat on the column will give you the string concatenation:
A Group By recipe with concat on the column will give you the string concatenation:
That was exactly what I was after, thank you so much! Spent quite a few hours trying to find a solution!!
Also see below for a solution that doesn't group the rows.
And please mark the thread as acepted solution ๐
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.