Join Multiple tool icon

Join Multiple Tool

Last modified: November 05, 2021

One Tool Example

Join Multiple has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer Cloud.

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

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. See Join Tool for more information. 

Configure the Tool

Select how to perform the join.

Join by Record Position

Select this option when the input tables to be joined have the same column structure, and the data is joined by its position within the 2 tables.

  • Only Output Records that Join from All Connections: Select this box to only allow rows that meet all Join criteria to be passed.
  • Output All Records: All rows are returned including NULL field values where rows did not meet 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.

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.

  • Select the column to join on for each input via the provided dropdowns. Designer Cloud automatically selects the join column for an input if the same column name is already selected for another input.
  • If you want multiple join columns, you can configure an additional row of join columns. Use the dropdown to choose an additional join column for each input.
  • To delete a join column, select the trashcan button.
  • Cartesian Joins: Choose how you want to handle Cartesian joins. Cartesian joins occur when every row of a table is joined to every row of another table. For example, if table A has 100 rows and is joined with table B, which has 1,000 rows, a Cartesian join results in 100,000 rows. These joins are computationally expensive.
    • Error on Multidimensional Joins of More Than 16 Records: An error is reported in the Results window that a multidimensional join has occurred and downstream processing stops.
    • Warn on Multidimensional Joins of More Than 16 Records: A warning is reported in the Results window that a multidimensional join has occurred.
    • Allow All Multidimensional Joins: The multidimensional join occurs with no error or warning reported.

Select, Deselect, and Reorder Columns

To include a column in data, check the box next to the column name. Uncheck the box to exclude the column.

To reorder the columns of data...

  1. Select and hold the reorder icon, and drag the column up or down.
  2. Select to highlight a row and use the Up or Down arrows to move the rows to a new location.

The Unknown column is selected by default. It allows you to create new columns in the data. Move the column to the location where you want a new column to be.

Modify Data Type and Size

To change the supported length (characters for string and numeric fixed decimal types) or measurement (bytes for other numeric types) of data in a column, select Size and enter a number. Size varies by data type and can be edited for fixed decimal numeric types and all string types.

Use the [data type]: Forced option to ensure a column always contains the expected data type.

Rename a Column or Add a Description

  • To change the name of a column, select Rename and enter the new name.
  • To add a description, select Description and enter a description.

Decimal Separators

To use commas as decimal separators, instead of periods, select Use Commas as Decimal Separators (String/Numeric Conversions Only).

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.