What does it do?
Allows you to combine (vertically) two or more datasets – i.e. like a SQL Union.
|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