What does it do?

Allows you to combine (vertically) two or more datasets – i.e. like a SQL Union.


Setting Description Notes
Merge Method Determines how columns are combined “Use common columns only” – combines columns only if they exist in all datasets
“Use all columns” – combines columns regardless of whether they exist in all datasets
Add ‘source’ reference If selected, adds a column to the output indicating which input dataset each row originated from
Convert inconsistent data types to text By default, two columns are only considered as matching if they have the same name and data type
Use this option to get round this by converting columns with the same name, but different data types to text



Tips & Tricks