Create a MagicETL function to Split Column and Dynamic Unpivot

mberkeley Member
edited February 2023 in Other Ideas

I have a column that contains multiple values. I would like to be able to flatten these values.


Document ID Author(s)

12 Bob^Sally

13 Bob

14 Fred^Ann^Sally

I would want the output to be:

Document ID Author(s)

12 Bob

12 Sally

13 Bob

14 Fred

14 Ann

15 Sally

3 votes

Submitted · Last Updated