Append If Missing

About Append If Missing

Append If Missing adds a column to a dataset if it doesn’t already contain it, and populates that column. If the dataset does contain a column with that name, no extra columns are added. The new column will be added to the right edge of the dataset.

Using the Append If Missing operation

To add an Append If Missing operation to your pipeline:

  1. Open the ‘Add Operation’ popup and select ‘Append If Missing’.
  2. In the ‘New column’ field, select a column name from the list of existing columns, or enter a new column name.
  3. Enter a value to populate the column.

Example

We want every incoming dataset to contain the column ‘Ceding Company’, but some datasets do not contain the column.

Input data
ID
LoB
Amount
1
car
100
2
life
1000
3
car
100

Apply the following settings

Output data
ID
LoB
Amount
Ceding Company
1
car
100
InsureRe
2
life
1000
InsureRe
3
car
100
InsureRe

Datasets that already contain the column ‘Ceding Company’ will be unchanged.

Datasets that do not contain the column ‘Ceding Company’ will have the column added, populated with the value ‘InsureRe’.