Union
Abstract
Add additional rows to your data by appending rows from another data set.
Add additional rows to your data by appending rows from another data set.
The number of columns added depends on the number of matching columns shared by both data sets.
Input and output
To use this tool, you need at least one matching column shared by both data sets.
When you build this tool, it appends matching columns from the second data set to the end of the first data set.
When to use this tool
Use when you want to combine data sets, but limit the number of columns to only those relevant to the first data set.
When you want to combine data sets without restrictions, use the Join tool instead.