The Append tools combines each row of your first dataset with each row of your second dataset. It is typically used when you want to “attach” a couple of columns of static data to a larger dataset.
Careful with the Append tool. The Append tool works by combining every row from each of the two input datasets. So if you have 10 rows in dataset one and 100 rows in dataset two, you will create an output of 1.000 (10 * 100) rows by appending them together. This is also known as a cross join or a cartesian product and will slow down performance.

​
Configuration

The Append tool doesn’t require any configuration. All you have to do is connect your two datasets and run the tool.

​
When To Use

When you need to add a couple of extra columns to your main dataset, the Append tool is the best method to do so.
  • You might have an department column, a reference date column or a third option that you need to attach to your dataset (see Example below)
  • If you truly need to cross join you’re dataset, the Append tool is the way to go.

​
Examples