Create a MagicETL function to Split Column and Dynamic Unpivot

mberkeley

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