Skip to main content

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

  1. 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 the data, select the checkbox. Clear the checkbox to exclude the column.

  • To reorder the columns of data:

    1. Select and hold the reorder icon, and drag the row up or down.

    2. 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.

View More Actions

After you highlight columns of your data in the Columns to Keep table, select the More Actions menu from the 3-dot icon to view configuration options...

  • Select: Use the select submenu to quickly deselect duplicate columns.

  • Move Columns to Top: Move highlighted columns to the top of the table.

  • Move Columns to Bottom: Move highlighted columns to the bottom of the table.

  • Add Prefix: Add a prefix to highlighted column names.

  • Add Suffix: Add a suffix to highlighted column names.

  • Clear Column Renames: Remove the new name for either all columns or only the highlighted columns.

  • Change Data Type: Change the data type of highlighted columns at once.

  • Remove Missing Columns: Remove all columns that are no longer included in the data.