Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Output: Builds an Object of the data from the columns Qty and Amount .

You can also specify ranges of columns using the tilde (~) operator:

d-

...

nest col:Column1~Column20 as:'bigNest'

Output: Nests the data from columns Column1 and Column20 and all columns displayed in between them in the data grid into the new column bigNest.

d-s
snippetusage

Required?Data Type
YesString (column name)

...

In the following example, furniture product dimensions are stored in separate columns in cm.

CategoryNameLength_cmWidth_cmHeight_cm
benchHooska118.1174.9346.34
lampTansk30.4830.48

165.1

bookshelfBrock27.94160.02201.93
couchLoafy9522783

TransformTransformation:

Use the nest transform to bundle the data into a single column.

d-

...

trans
RawWrangletrue
p03Value'Dimensions'
Typestep
WrangleTextnest col:

...

Length_cm,Width_cm,Height_cm as:'Dimensions'
p01NameColumns
p01ValueLength_cm,Width_cm,Height_cm
p02NameNest columns to
p02ValueArray
p03NameNew column name
SearchTermNest columns into Objects

Results:

CategoryNameLength_cmWidth_cmHeight_cmDimensions
benchHooska118.1174.9346.34{"Length_cm":"118.11","Width_cm":"74.93","Height_cm":"46.34"}
lampTansk30.4830.48

165.1

{"Length_cm":"30.48","Width_cm":"30.48","Height_cm":"165.1"}
bookshelfBrock27.94160.02201.93{"Length_cm":"27.94","Width_cm":"160.02","Height_cm":"201.93"}
couchLoafy9522783{"Length_cm":"95,"Width_cm":"227","Height_cm":"83"}

...