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.