Union
Add additional rows to your data by appending rows from another dataset.
Add additional rows to your data by appending rows from another dataset.
The number of columns added depends on the number of matching columns shared by both data sets.
Input and output
The Union tool requires two data sets. Using this tool requires 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.
Configuration
Use the following configuration options to help create your unions.
Go to the Pipes module from the side navigation bar.
On the Pipes tab, find the pipe you want to work with. Click the pipe to open. For more information about pipes, see the Creating a pipe documentation.
In the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.
Click
+ Tool.
The Tools modal opens where you can add tools, such as the Aggregate tool to your pipe.
In the Tools modal, search for Union. Click + Add tool.
Tip
You can also find the Union tool in the Combine section.
Connect the tool to your data sets.