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.