locked
How can I find the differences between two tables. RRS feed

  • Question

  • Hi,

    I have two tables.  Table 1 has 7800 rows and table 2 has 20000 rows.  I match 2 to 1 and get about 4800 rows that match.  I also need to get the other 3000 rows from table 1 that didn't match table 2.  I usually use sql to just do a sub select.  For example select * from Table 1 where key is not in (select key from table 2) and it gives me the differences.  I'm not seeing a way to do this using power query can anyone help...

    Thanks


    Donald R. Landry

    Tuesday, August 30, 2016 10:55 PM

Answers

  • Hi Donald

    When You Merge the two tables rather than a Left Join between the two - select a Left Anti Join. This will give you all the non matching rows from the second table.

    I did take a screen-grab for this - but I can't post a t the moment

    Many thanks

    DAve

    Wednesday, August 31, 2016 2:42 PM