cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lukassimoncic Frequent Visitor
Frequent Visitor

Right Anti Join Returns Null

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:

 

matched.png 

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

 

 

 

result.png 

 

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

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
drewlewis15 Member
Member

Re: Right Anti Join Returns Null

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

2 REPLIES 2
drewlewis15 Member
Member

Re: Right Anti Join Returns Null

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

lukassimoncic Frequent Visitor
Frequent Visitor

Re: Right Anti Join Returns Null

Thanks!