Compare two tables and return missing codes

[edumach]

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

[edumach]

@AbhinavJoshi obrigado

[AbhinavJoshi · Accepted solution]

Hello @edumach, 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

[edumach]

@mussaenda This is just a sampling, there are many codes, the table has 1.5 million records

[mussaenda]

Hi @edumach ,

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.

[mussaenda]

Hi @edumach ,

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?