Split and Fold Columns

Description

This activity splits a column’s values into multiple rows based on a specified separator. The original data in other columns is duplicated across the new rows.

Input

Data Only

Output

Transformed Data

Configuration Fields

• Column To Split Specifies the column whose values should be split and expanded into multiple rows.
• Separator Defines the delimiter used to split the column values.

---

Sample Input

ID	Name	Tags
101	John	Red,Blue,Green
102	Alice	Yellow,Orange
103	Mark	Black
104	Emma	White,Gray,Silver
105	Bob	Pink

Sample Configuration

Sample Output

ID	Name	Tags
101	John	Red
101	John	Blue
101	John	Green
102	Alice	Yellow
102	Alice	Orange
103	Mark	Black
104	Emma	White
104	Emma	Gray
104	Emma	Silver
105	Bob	Pink

---