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

Unlock the full course today

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

Overview of joins in Power Query

Overview of joins in Power Query - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Overview of joins in Power Query

“

I really want you to get this. We are going to start talking about the merges or joins in Power Query. They can feel advanced, but I know that from Day 1 when I started working with Excel, I had two datasets and I needed to pull data from one dataset over to the other one. It was messy. I could have used VLOOKUP if I had it, but these joins and Power Query would have been so much better because I had to do this over and over again. Now, when the merges showed up in Power Query, they were hard to understand. And that's why I want to go slow through this and help you think about it, because they're named things like outer join, left anti and I'm sitting there thinking and tie what? Left and right of what? I'm going to show you. Just think about it this way. We have two datasets. We have Angus down through Poppy. RSVP for this culinary arts workshop. The other dataset. People who attended the workshop Brit, Carla, et cetera, down to Poppy. Now, we can see Angus is on the RSVP list, but…

Contents