From the course: Excel: Power Query (Get & Transform) (2020)

Unlock the full course today

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

Left anti join

Left anti join

From the course: Excel: Power Query (Get & Transform) (2020)

Start my 1-month free trial

Left anti join

“

- [Instructor] You and I are holding a new product orientation. We've got two data sets, people who are required to attend, and people who are enrolled. Now we want to find out who is required and not enrolled. In other words, we want to fish out our recalcitrant people. Recalcitrant meanin' havin' an obstinately uncooperative attitude toward authority or discipline, see they're ornery. All right who are our ornery people? We are going to do a left anti-join. The left anti-join means we're going to put our required people on the left side and we want everybody who does not have a match from the right or enrolled side. Okay, let's do it, cursor in the data set. Data, From Table/Range, here is our required query. Close and load this as a connection only. Okay next, our enrolled query. And rather than go all the way back out, I want to show you a trick. This is the enrolled query. I'm going to stay right here and go to…

Contents