Joining row data

pauljames
pauljames Contributor

Hi, I'm trying to combine several row data that have a similar dimension.

For instance, i want to aggregate all of the lists_name's into one row next to 2024 Collection - Launch #4.

so turn this…

into this…

IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can do this with a Magic ETL Group By tile to combine the values with a comma separator.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can do this with a Magic ETL Group By tile to combine the values with a comma separator.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • pauljames
    pauljames Contributor

    Wow, didn't know that was an option. Thanks Grant!

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!