Forum Discussion
lukassimoncic
7 years agoNew Member
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:
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!
You need to expand the table in the far right columns labeled "New".
2 Replies
- drewlewis15Solution Specialist
You need to expand the table in the far right columns labeled "New".
- lukassimoncicNew Member
Thanks!