Create a MagicETL function to Split Column and Dynamic Unpivot

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

Ex:

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

Tagged:
3
3 votes

Submitted Β· Last Updated