Split and fold

This processor splits the values of a column based on a separator and transforms them into several rows.

For example, with the following dataset:

customer_id	events	browser
1	login,product,buy	Mozilla
2	login,product,logout	Chrome

Applying “Split and Fold” on the “events” column with “,” as the separator will generate the following result:

customer_id	events	browser
1	login	Mozilla
1	product	Mozilla
1	buy	Mozilla
2	login	Chrome
2	product	Chrome
2	logout	Chrome

All columns except the folded column are copied in each new line.

For more details on reshaping, please see Reshaping.