Split Multi Value Column values into Separate Columns
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)…
