Comparing tables

Question

Good morning,
I would like to compare 2 tables -> old and new. In the new table, 2 positions have been added. I would like to know which are they.
I have been trying to solve this problem for some time - without success. Please help.

Would it be possible to use the filter tool to obtain the changes that have taken place?

Old table.xlsx

New table.xlsx

AngelosPachis · Accepted Answer

Hi @Luk88kk ,

I think the best solution here is to use a Join tool, to Join the two tables on the ISO 3166 Code column. Countries that exist in both tables will fall out of the J output anchor of the Join tool. Countries  that are not included in one of the two tables (and hence can't be joined) will fall out of the L or R output anchors, depending where they originate from.

If your new table for example is connected to the R input anchor of the tool, you should see those two records for IT and HU falling out of the R output anchor.

Hope that helps,

Angelos

afv2688 · Accepted Answer

Hello @Luk88kk,

you can achieve this easily with just a joint tool. By comparing the columns of the ISO code you would be able to see which countries have been added.

Hope that helps

Regards