The Join Tables tool lets you combine the columns from two tables (worksheet ranges) to create a new table.
- Matching rows: Known as an SQL inner join, this option outputs only rows where there is a match between columns.
- All table 1 items: Known as an SQL left outer join, this option outputs all of the table 1 fields and only the table 2 fields where the columns match.
- All table 2 items: Known as an SQL right outer join, this option outputs all of the table 2 fields and only the table 1 fields where the columns match.
- Table 1: Select the workbook, worksheet, and range where Table 1 is located. The "tables" do not have to be Excel tables - any range will work.
- Table 2: Select the workbook, worksheet, and range where Table 1 is located.
- Select Matching Columns: In the second step of the Join Tables dialog, you select the columns to match on between table 1 and table 2.
- Ignore case for text matching: If checked, the text casing is ignored when comparing the fields in matching columns.
- Select Output Columns: Select the columns that you want included in the output table.
- Output To: You can output to a new worksheet (in the same workbook as Table 1) or to a new workbook.
- Worksheet name: Optional field to name the output worksheet.