How to do Split and Fold data based on delimiter

Matillion ETL
1

I have one table that contains multiple columns. I want to do Split and Fold the "Make" column data based on the delimiter (,). See the attached input and output example and let me know how to do this in Matillion.

069Tm000002KnWYIA0_0D5Tm000005QPikKAG
069Tm000002KnWYIA0_0D5Tm000005QPikKAG1029×269 42.7 KB

2

If you know the maximum number of items that you will have in the Make column, you can try using the Split Field component.

https://docs.matillion.com/metl/docs/2043156/

 

And then use pivot / unpivot to get the columns as rows.