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.

Apply the following settings

• New column: Ceding Company
• Populate with value: InsureRe