Right Anti Join Returns Null

[lukassimoncic]

Hi there!

I have 2 tables containing a list of parts, one from last month (Old, 165658 rows) and another from this month (New, 166761 rows). I want to do a right anti join so I can only display the rows from "New" that are different from "Old". So I go to the power query editor --> merge queries --> merge queries as new. See the image below:

 

Column 2 is the matching column, there are 165566 matches. The result is just a table of null values. (See the next image).

 

Could someone please tell me what I'm doing wrong? 

Thanks!

[drewlewis15 · Accepted solution]

You need to expand the table in the far right columns labeled "New".

[lukassimoncic]

Thanks!