append two tables with no duplications

One.xlsx

Two.xlsx

I have two files I want to append them into one single table.

file 1:

file 2:

As you see, the ID for both files are Product + Location to check if any “Product + Location” has duplicates.

If any ID is already in Table 1, I do not want to append from table 2. Hence, I only want ID which is not in Table 1 append from table 2.

If I use “Duplicate Row Filter” with “First” in row chosen in case of duplicate…does the first row always comes from Table 1?

If not, what would be the best way to do it?

As I have a huge set of data in both table I don’t want them to be mess up. Thank you so much.