Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

Excerpt

Creates an Object or Array of values using column names and their values as key-value pairs for one or more columns. Generated column type is determined by the into parameter. 

The nest transform is the opposite of unnest, which unpacks Object data into separate columns and rows. See Unnest Transform.

D s
snippetBasic

ItemAItemB
2233
4455

Object example:

D code

nest col:ItemA,ItemB into:'obj' as:'myObj'

Output: See below.

ItemAItemBmyObj
2233{"ItemA":"22","ItemB","33"}
4455{"ItemA":"44","ItemB","55"}

Array example:

D code

nest col:ItemA,ItemB into:'array' as:'myArray'

Output: Output arrays do not include the column name.

ItemAItemBmyArray
2233["22","33"]
4455["44","55"]

D s
snippetParameters

D code

nest col:column_ref [into: object|array] [as:'new_column_name']

TokenRequired?Data TypeDescription
nestYtransformName of the transform
colYstringSource column name
intoNstringData type of output column: object (default) or array
asNstringName of newly generated column

D s lang notes

col

Identifies the column or columns to which to apply the transform. You can specify one column or more columns. 

Include Page
col_multi Parameter
col_multi Parameter

For each listed column, a new pair of key and value columns is generated. 

D code

nest col: Qty, Amount

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 code

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)

into

Defines the output column type. Accepted values:

  • object 
  • array

If this parameter is not specified, the output type is Object.

D s
snippetusage

Required?Data Type
No (Object is default)String (data type name)

as

Include Page
as Parameter
as Parameter

D code

nest col: CustId,ProdId as:'masterNest'

Output: Nests the data from the columns CustId and ProdId into a new column called, masterNest.

D s
snippetusage

Required?Data Type
NoString (column name)


D s
snippetExamples

Source:

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

ProductCategoryProductNameLength_cmWidth_cmHeight_cm
benchHooska118.1174.9346.34
lampTansk30.4830.48

165.1

bookshelfBrock27.94160.02201.93
couchLoafy9522783

Transform:

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

D code

nest col:Length~Height as:'ProductDimensions_cm'

Results:

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

ProductCategoryProductNameLength_cmWidth_cmHeight_cmProductDimensions_cm
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"}

D s also
labelwrangle_transform_nest