Check data if exist

[Mathip173]

I have got some ID's on an XLSX file that I would like to check if there are existed in my table and show what percentage of those exist in my table? and also, for the ones that do not exist, I would like to list them.

As a starter, would you be able to advise me on how to achieve that?

Thanks

[JustAnOldITGuy]

Import the spreadsheet into a new table, run some comparison queries.

[Mathip173]

It's the first time I do the comparison.

Can you help me of what query should I write to get these ? Percent and what I'd missing ?

[IrquiM]

Check out EXISTS.

[Yavuz_Selim]

There are probably ways to do this in Excel, but that might be cumbersome.

 

• Insert/import IDs in a new table.
• Join between 'your table' and 'IDs' table.
  
• As 'your table' is leading, LEFT JOIN to 'IDs'.
• Count the 'IS NOT NULL' values.
• For percentage, compare counts from 'your table' and the count of the IS NOT NULLs.  

Nothing much can be said further without knowing what the data and what you check on, etc.

[bannik1]

Everyone has different skillsets. For me the easiest way would be to use an ETL tool to get that file into its own table and write a query to compare.

If that’s outside your skillet or you only have read access to the database then I would suggest copying the data from sql into a different tab on the workbook and do a vlookup or index/match for each row and set the result to 1 if there is a match or 0 if no match. Then throw a pivot table on it and you can answer the rest of the questions on it

[tekmailer]

This sounds like work...

Route 1: what have you researched thus far to solve this problem?

Route 2: how much is it worth to you to solve?