If you select this checkbox, the rows that contain duplicated key values, will be added after all rows in the Master Table: Not to lose data and to add such rows to your main table, select one of these options: When you update the same tables together with your colleagues, there can occur duplicate values on different rows that contain unique information. When you check the Add non-matching rows to the end of the Master Table option, the rows with such values will be pasted after all rows of the Master Table: Thus, the names from 21 to 25 in your lookup table are non-matching. The second list contains names from 1 to 25. The main table has the names from 1 to 20. For example, both tables contain a column with names. Tick off the option Add non-matching rows to the end of your Master Table to add extra rows that are not present in the Master Table.
On the last step of Merge Two Tables, you can see a number of adjusting options you can select to fine-tune the results.
Select additional options for merging your data
