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

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Merge with multiple fields

Merge with multiple fields - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Merge with multiple fields

“

There was a mandatory Karaoke event held. And now we've got two datasets. In columns B, C, and D, we have who attended and if they sang or not, or how many songs they did sing. Wow. This was an intense version of mandatory fun. Over in columns G and H, we've got everybody who was supposed to attend. Scroll down. Right. And there are more people who are required than people who actually attended. Our goal is to fish out the people who did not show up. Got to find the fun haters who are among us. Now, look at the data. We can see that we need an anti-join because we want to know who is on the all personnel, who is not also on the attended list. And we have to match up two fields because let's look at the data. We have a Keith Cline and a Lonnie Cline. We have a Steve Mayfield and a Todd Mayfield. Let's scroll down to more Lee's; Lee Simonson, Lee Thornton. So how do we match these up? I'm in the data tab. I'm going to go to Queries and Connections. We've got to Karaoke Query and the all…

Contents