A default Column Definition is automatically created when a Mapping Group is created. The default Mapping Group Column Definition has a single primary column named Value. The contents of the Value column are changed by the Functional Transformations defined in the Mapping Group.

Mapping Group default Column Definition

Modifying a Column Definition

The Column Definition of the Mapping Group can be modified at any time to change the data type or name of the column. Additionally, columns can be added to the Column Definition. Any columns added to the Column Definition are used to support the functional transformation (mapping) of the primary column. This is referred to as Conditional Mapping. The additional columns are not transformed by the Mapping Group.

To modify the column definition of the Mapping Group:

  • Click the Columns tab of the Columns-Files navigation pane

  • Select Edit Columns.

    • The primary column is noted with a heading.

    • The name of the column and the data type can be modified as needed.

While not necessary, it is often helpful to update the primary column name to match the name of the column from the Pipeline to which the Mapping Group will be applied.

Modify Mapping Group default column definition

Adding Columns

Add additional columns to the Mapping Group Column Definition as needed to support Conditional Mapping. To add columns:

  • Click Edit Columns.

  • Click the blue plus sign (+) in the Columns Definition section.

  • A new column will be added.

  • Specify the Data Type and Column Name for the new column.

  • Repeat for each of the columns needed in the Mapping Group.

  • Click Save once all of the needed columns have been added.

📓 The data type of a new column defaults to STRING but should be updated to match the data type of the column from the Pipeline to which the Mapping Group column will be associated.

Adding columns to a Mapping Group

📚 Related Topics from this Section:

Column Definition

Mapping Groups

Conditional Mapping

Pipelines (Functional Transformations)

Did this answer your question?