Construct Struct
-
DarkLight
Construct Struct
-
DarkLight
This article is specific to the following platforms - BigQuery.

Construct Struct Component
Creates structured data from flat columns and outputs the structure into a new column.
The structured data can be thought of as key:value pairs. This component creates new 'Target' Columns with the form <StructName>.<KeyName> and each row in that column would be <Value>.
Properties
Property | Setting | Description |
---|---|---|
Name | Text | A human-readable name for the component. |
Column Mapping | Mapping | Choose a Source Column from the data flow in your Transformation job and map it to a new Target Column with a name of your choosing. In the context of structured data, the Source Column is a list of values and the Target Column is their respective key. |
Output Column | Text | Specify a new column that your structured data will populate. When sampling data, this will appear as a prefix to Target Column names. Thus, all columns with the same prefix can be considered part of that same structure. |