Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...