Combine [unique] strings separated by comma

Options

Hi all

Anyone know if this is on the horizon? Combining unique values in a comma separated string. Anyone know?

The issue is mapped out in the 4 year old post I've linked to below.

Thanks

Best Answer

  • ColemenWilson
    edited November 2023 Answer ✓
    Options

    This is possible in magic ETL. Use GROUP_CONCAT() or the group by tile to achieve this. The first step would be to filter the data to unique values and then group concat Field C with Field A as the partition in the case above.

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

Answers

  • ColemenWilson
    edited November 2023 Answer ✓
    Options

    This is possible in magic ETL. Use GROUP_CONCAT() or the group by tile to achieve this. The first step would be to filter the data to unique values and then group concat Field C with Field A as the partition in the case above.

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