Join Multiple Tool
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.
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. Visit 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 field structure, and the data is joined by its position within the 2 tables.
- Join by Specific Fields: Select this option when the input tables have one or more fields in common (like an ID) and the data is joined based on the shared field.
- Select the field to join on for each input via the provided dropdowns. Designer automatically selects the join field for an input if the same field name is already selected for another input.
- If you want multiple join fields, you can configure an additional row of join fields. Select the dropdown to choose an additional join field per input.
- To delete a join field, select the field to remove and select the delete button (minus icon) on the right.
- Cartesian Joins: Choose how you want to handle Cartesian joins. Cartesian joins occur when every row of one 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 CPU intensive.
- Allow All multidimensional Joins: The multidimensional join will occur with no error or warning reported.
- Warn on multidimensional joins of more than 16 Records: A warning is reported in the Results window that a multidimensional join has occurred.
- 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.
- Only Output Records that Join from All Inputs: Select this box to only allow records that meet all Join criteria to be passed. When unselected, all records are returned including NULL field values where records did not meet Join criteria.
- Use the table to modify the incoming data stream. Each row in the table represents a column in the data.
Select, Deselect, and Reorder Columns
To include a column in data, select the check box to the left of the column name. Deselect the check box to exclude the column.
To reorder the columns of data...
- Select to highlight a row, or select and drag down to highlight multiple rows.
- Click the Move Up or Move Down arrows, or right-click and drag, to move the rows to a new location.
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 DataType 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. This is helpful when creating macros.
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.
View More Options
After selecting or highlighting rows (columns of data) in the table, select Options to view more configuration options:
- Save/Load: Save Field Configuration as a .yxft file. The Alteryx Field Type File is a text file that can be used in other workflows using the Load Field Names or Load File Names and Types options.
- Select: Select or deselect all or highlight columns. Options include Select All and Deselect All.
- Change Field Type of Highlighted Fields: Change the data type of all highlighted columns at once.
- Sort: Sort the column order in ascending or descending order. Options include Sort on Original Field Name, Sort on New Field Name, and Sort on Field Type, or Revert to Incoming Field Order.
- Move: Move highlighted columns to the top or bottom of the list.
- Add Prefix to Field Names: Add a prefix to the selected or highlighted column name.
- Add Suffix to Field Names: Add a suffix to the selected or highlighted column name.
- Remove Prefix or Suffix: Remove the prefix or suffix from the selected or highlighted column name.
- Clear All Renames: Remove the new name for all columns.
- Clear Highlighted Renames: Remove the new name for all highlighted columns.
- Revert All to Original Type & Size: Undo all changes to type and size in all columns and use the original values.
- Revert Highlighted to Original Type & Size: Undo changes to type and size in the selected or highlighted columns and use the original values.
- Forget All Missing Fields: Remove all columns that are no longer included in the data.
- Forget Highlighted Missing Fields: Remove all highlighted columns that are no longer included in the data.
- Deselect Duplicate Fields: Deselect the second column when duplicate column names exist. This option is only available with multiple inputs.