Concatenate in Magic ETL

rupinderkaur87 · 2023-11-09T20:43:31+00:00

There was an error rendering this rich post.

rupinderkaur87

i have data like this :

And with magic ETL want to concatenate contents of column C for same values in Column A.

Desired result:

Result with Group by's concatenate

Find more posts tagged with

Accepted answers

ColemenWilson

Use the group by tile, set Member Number as the Grouping field and then select Add Formula and use something like the following:

GROUP_CONCAT(DISTINCT
CASE WHEN ` 3rd Party` IS NOT NULL
THEN ` 3rd Party` END)

GrantSmith

You likely have some blank spaces in your 3rd party field. To handle these you can ignore empty fields:

GROUP_CONCAT(DISTINCT
CASE WHEN TRIM(COALESCE(`3rd Party`, '')) <> ''
THEN ` 3rd Party` END)

All comments

ColemenWilson

GrantSmith

You likely have some blank spaces in your 3rd party field. To handle these you can ignore empty fields:

GROUP_CONCAT(DISTINCT
CASE WHEN TRIM(COALESCE(`3rd Party`, '')) <> ''
THEN ` 3rd Party` END)

rupinderkaur87

Thanks @GrantSmith and @ColemenWilson for the solutions.