From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Merging and segmenting data: Anti-join

Merging and segmenting data: Anti-join

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Merging and segmenting data: Anti-join

“

- [Instructor] All right, check this out. I am going to show you one of the six joins in Power Query. For the sake of this course, since we want to do some fast bite-sized stuff, I'm going to show you one query, one of the six, that are in the interface of Power Query. I'm going to show you an anti-join with two criteria. Here we have my list and my friend Connie's list. Here are the songs and artists and I want to find out which songs are not on my list that are on Connie's list. And we're going to do a right anti-join to figure that out. We're starting with the queries already. My list and Connie's list, you can see those over on the right side. Here we go, let's do this right anti-join. Okay. Data, get data, combine queries, merge. I want to put my list and then Connie's list. We got to match artist and musician because, you know, like, if we look over on the side, we have Prince sang Kiss. Tom…

Contents