Split Multi Value Column values into Separate Columns

gwenpowers

Hi! I have a column with multiple values, separated by a comma. I am able to use the Split Column in Magic ETL and place the values into new columns. However, I need it to be added into a new column based on the value.

For ex.:

Fruit, Vegetables (Fruit would go in Fruit Column and Vegetables would go in Vegetable Column)

Dairy, Vegetables, Meats (Meats would go in Meat Column, Dairy would go in Dairy Column, and Vegetables would go in Vegetable Column)

Currently, the new columns just add the 1st and 2nd values - So the new column would have both Fruit and Dairy in it.