课程: Excel: Power Query?(Get & Transform)

今天就学习课程吧！

今天就开通帐号，24,100 门业界名师课程任您挑！

Merge with multiple fields

Merge with multiple fields - Microsoft Excel教程

课程: Excel: Power Query?(Get & Transform)

开始一个月试用 购买团队方案

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…

内容