Link two tables or worksheets to create a single worksheet with columns from both.
How does Join differ from Append?
Join combines the columns of two tables or worksheets. Append combines the rows of two tables or worksheets. Join adds columns to a worksheet. Append adds rows.
What's the difference between the three different Join options?
The different options tell DSCVR which rows to include or exclude in the joined data.
- Keep all rows to retain all of the rows from the current worksheet and all of the matching rows from the foreign table.
- Keep only rows that have a match to retain only rows from both the current and foreign tables that match. This option removes rows from both tables that do not have a match.
- Keep only rows that do not have a match to retain only those rows in the current worksheet that have no explicit match in the foreign table. This option removes rows from the current worksheet that do not have a match in the foreign table.
What does "Allow next closest matching" mean?
There may be cases where you don't require an exact match of column data in order to join two tables. In these cases, match the row in the current worksheet with the row containing the next closest value in the foreign table or worksheet. This option is especially useful for date columns.
Some, or all, of my data is missing. What should I do?
Check the join type. You may have also joined on two columns that do not contain matching data.