Skip to content

    • Magic ETL

    Magic ETL

    Concatenate in Magic ETL

    Member
    in Magic ETL

    i have data like this :

    image.png

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

    Desired result:

    image.png

    Result with Group by's concatenate

    image.png image.png

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Coach
      edited November 2023 Answer ✓

      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)

      If I solved your problem, please select "yes" above

    • Coach
      Answer ✓

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

      1. GROUP_CONCAT(DISTINCT
      2. CASE WHEN TRIM(COALESCE(`3rd Party`, '')) <> ''
      3. THEN ` 3rd Party` END)
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      edited November 2023 Answer ✓

      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)

      If I solved your problem, please select "yes" above

    • Coach
      Answer ✓

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

      1. GROUP_CONCAT(DISTINCT
      2. CASE WHEN TRIM(COALESCE(`3rd Party`, '')) <> ''
      3. THEN ` 3rd Party` END)
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Thanks @GrantSmith and @ColemenWilson for the solutions.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories