From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Overview of Power Query joins

Overview of Power Query joins - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Overview of Power Query joins

“

- [Instructor] Since we're talking about managing and analyzing data, it is vital for me to share with you Power Query's six joins. Now this is going to be a brief overview, and I do have a course on the library called Excel Power Query Getting Transformed, where I do a much deeper dive. Power Query gives us six joins in the menu, Full outer join, left outer, right outer, inner join, left anti join, right anti join, and they can be hard to understand. Anti join? That sounds like the opposite of join. So let's look at this example. We have two sets of data representing people who live in this spectacular lakefront apartment building. We've got the owners and residents, and then notice that Andy is both an owner and a resident. Hannah is only a resident. Enid is both an owner and a resident, and Margie is only an owner. Okay, let's look at the data this way. Now we've got three data sets. People who are owners only, people who are residents only, and the three people who are both a…

Contents