Join Multiple Tool

The Join Multiple tool combines two or more inputs based on a commonality between the input tables. Only the joined records are outputted through the tool, resulting in a wide (columned) file.

Configuration Properties

  1. Select how to perform the Join. The two options are by record position, or by specific field.

    Join by Record Position: Select this option when the input tables to be joined have the same field structure, and the data will be 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 will be joined together.

  2. Choose the preferred behavior for how to handle Cartesian Joins.

    Cartesian Joins: A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself. A Cartesian join is very CPU intensive, and is usually done by mistake.

    Choices on how to handle Cartesian joins include:

  3. Only Output Records that Join from all inputs checkbox. Checking this box will only allow records that meet all Join criteria to be passed. Leaving this box unchecked will result in all records being returned, along with NULL field values where records did not meet Join criteria.
  4. From the configuration properties, you can rename fields, reorder fields, sort ascending/descending, and select the fields needed from the inputs.