Forum Discussion
Compare two tables and return missing codes
I need to check which codes(CPF) are missing in the MON_VG_20230723_000043_Full table, when I compare it with the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023-102500 table.
The result should be a list of the codes that are missing from the MON_VG_20230723_000043_Full table
Hello Anonymous, One way to achieve this is using merge queries in Power Query Editor. Merge your two tables based on the Code that exists on the both table. Once it is merged based on the key, click on keep nulls on the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023 table. It will give you the codes that doesn't exist on the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023 but exists on the MON_VG_20230723_000043_Full table. I hope it helps!
Thanks,
Abhinav
5 Replies
AbhinavJoshi obrigado
Hi Anonymous ,
my suggestion is to have a masterlist of all the codes and then you can lookup the values
from your provided data, the missing codes are ...0006 and ...0007, right?
mussaenda This is just a sampling, there are many codes, the table has 1.5 million records
Hi Anonymous ,
I understand. That is hy you need a masterlist of your codes.
You can append the codes as new table and remove the duplicates the use it as your lookup table.
This just one of the ways.
Hello Anonymous, One way to achieve this is using merge queries in Power Query Editor. Merge your two tables based on the Code that exists on the both table. Once it is merged based on the key, click on keep nulls on the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023 table. It will give you the codes that doesn't exist on the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023 but exists on the MON_VG_20230723_000043_Full table. I hope it helps!
Thanks,
Abhinav
