Join Multiple Tool
Use Join Multiple to combine 2 or more inputs based on a commonality between the input tables. By default, the tool outputs a full outer join. Go to Join Tool for more information on all types of joins.
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Configure the Tool
Select how to perform the Join.
By Specific Columns: Select this option when the input tables have 1 or more columns in common (like an ID) and the data is joined based on the shared column.
Join by Specific Columns: Select the columns to join for each input. If you want multiple join columns, you can configure an additional row of join columns.
To delete a row, select the delete button (trash icon) on the row.
Select how to output the result of the Join.
Only Rows that Join from All Connections: Select this option to only allow rows that meet all Join criteria to be passed.
All Rows: All rows are returned, including NULL field values where rows did not meet the Join criteria.
Use the Columns to Keep table to modify the incoming data stream. Each row in the table represents a column in the data (for more details, go to the next sections).
Select, Deselect, and Reorder Columns
To include a column in data, select the checkbox. Unselect the checkbox to exclude the column.
To reorder the columns of data:
Select and hold the reorder icon, and drag the row up or down.
Select to highlight a row and use the up arrow or down arrow to move the rows to a new location.
Note
The Unknown column is selected by default. It allows new columns in the data. Move the column to the location where you want a new column to be.
Modify Data Type
To change the data type of a column, select Type, then select a new data type from the dropdown.
Rename a Column
To change the name of a column, select the Rename column associated with the column and enter the new name.