Thursday, April 16, 2020

Select Records in One Table that Aren't in Another Table


This video will cover the Anti Join feature in Excel Power Query. The scenario it fits would be where you want to select all records from one table that doesn't exist in another table. So when we are trying to check whether an item does not exist in another table it's going to be an anti join. Another example is when we are trying to find something that hasn't happened. However in this video we'll cover something that doesn't exist rather that something that didn't happen. So check it out!

No comments:

Post a Comment