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.