Page tree

Release 9.2


Contents:

   

This section provides a simple example of nesting columns into a new column of Object data type.

Source:

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

Transformation:

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

Transformation Name Nest columns into Objects
Parameter: Columns Length_cm,Width_cm,Height_cm
Parameter: Nest columns to Object
Parameter: New column name 'Dimensions'

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

This page has no comments.