...
For example, if you have a column of distinct strings separated by commas, such as:
ID | Fruit |
---|---|
1 | orange,lime,lemon |
2 | banana,mango,guava |
3 | avocado,peach,plum |
You can split the values into separate rows. Wrangler deletes the original column, creates a new column with one row for each value. Wrangler makes copies of all values in each of the other columns in the dataset:
ID | Fruit_1 |
---|---|
1 | orange |
1 | lime |
1 | lemon |
2 | banana |
2 | mango |
2 | guava |
3 | avocado |
3 | peach |
3 | plum |
Arrays (by flattening)
(More information coming soon…)
The FLATTEN directive separates the elements in a repeated field into individual records.
...