Contents x
    Construct Struct
      • Dark
        Light
      Contents

      Construct Struct

        • Dark
          Light
        Article Summary

        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

        PropertySettingDescription
        NameTextA human-readable name for the component.
        Column MappingMappingChoose 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 ColumnTextSpecify 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.
        What's Next