Join Multiple Tool

The Join Multiple tool combines 2 or more inputs based on a commonality between the input tables. By default, the tool outputs a full outer join. See Join Tool.

Configure the Tool

  1. 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 two tables.
    • Join by Specific Field: Select this option when the input tables have one or more field in common (such as an ID) and the data is joined based on the shared field.
      • Select the join field to join on for each input using the related list. Designer automatically selects the join field for an input if the same field name was already selected for a different input.
      • If multiple join fields are desired, an additional row of join fields can be configured. Click on the drop down to choose additional join field per input.
      • To delete a join field, select the field to be removed and click the delete button on the right.
      • Choose the preferred behavior on how Cartesian Joins are handled. Cartesian joins occur when every row of one table is joined to every row of another table; they are computationally intensive and typically done by mistake.
        • 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 will be reported in the Results window that a multidimensional join has occurred.
        • Error on multidimensional joins of more than 16 Records: An error will be reported in the Results window that a multidimensional join has occurred and downstream processing will stop.
  2. 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.
  3. Use the table in the Configuration window to modify the incoming data stream. Each row in the table represents a column in your data. The Field column in the table identifies the name of each column in the data and auto-sizes to fit column (field) names without cutting off any text (up to 40 characters).

    4. Search Fields

    Before you start updating your fields, you might want to limit your list so that you can perform updates on only a subset of the fields. This is also really helpful if your dataset contains many fields (columns).

    To do this, use the Search box at the top of the Configuration window. Enter a keyword and the Join Multiple tool searches the Field, Rename, and Description columns to return matches. The search is not case-sensitive.

    You can then perform various actions (like select, deselect, rename, etc.) on only the fields that were returned via your search. Think of the Search box as a way to filter your list of fields so that you can update only a subset of your data columns.

    To view your entire list of fields again, use the "x" icon to clear out the Search box.

    After you perform a search, only a subset of your data fields (columns) display. Please note that depending on what action you chose in the Options menu...

    • Some actions might apply to only fields shown.
    • Some actions might apply to all fields, regardless of which ones are shown.
    • Some actions might only apply to the specific fields that are selected (highlighted) in the list of fields.

    Because of this, please use caution when you perform actions on a subset of fields and double-check the results to make sure they are what you're expecting.

    Select, Deselect, Sort, and Reorder Columns

    Select and Deselect Fields

    To include a column in the dataset, check the check box to the left of the column name. Uncheck the check box to exclude the column. You can also use the select and deselect all check box at the top of the table to quickly select and deselect all visible fields.

    Sort Columns

    To sort the columns of data based on the column name...

    • Click on the column name to sort in ascending order.
    • Click on the column name a second time to sort in descending order.

    Depending on the language of your Designer instance, a different default sort order might be used. Consult the User Settings to read more about the default Sort Method.

    Reorder Columns

    To reorder the columns of data...

    • Select to highlight a row, or select and drag to highlight multiple rows.
    • Use 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 Data Type and Size

    Data Type

    Use the Type dropdown to change the data type of a column in your dataset.

    Data 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 Types and you can edit it 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 the Rename field and enter the new name.
    • To add a description, select the Description field and enter a description.

    View More Options

    After you select or highlight rows (columns of data) in the table, select the Options dropdown above the table 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 Field Names & 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. Depending on the language of your Designer instance, a different default sort order might be used. Consult the User Settings to read more about the default Sort Method.
    • 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.