Help Centre

Append if Missing
Adds a column to a dataset if it doesn’t already contain it. If the dataset does contain a column with that name, no extra columns are added.
Usage
appendIfMissing:
column: "<column to add>"
value: "<value of column>"


Example
Here we want to add the data source ‘company’ to every table
id
lob
amount
1
car
100
2
life
1000
3
car
100
applying the following
appendIfMissing:
column: "ceding company"
value: "insureRe"


would result in:
id
lob
amount
ceding company
1
car
100
insureRe
2
life
1000
insureRe
3
car
100
insureRe