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.

Merge with multiple fields

Merge with multiple fields

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

Start my 1-month free trial

Merge with multiple fields

“

- [Instructor] We hosted another round of Mandatory Fun. And now we want to know, is there anybody who skipped out? In columns B and C, we have the names of everybody who was verified as having attended. Over in columns G and H, is all of the personnel, who were supposed to have been there. So first of all, we want to know, who's in All Personnel, that is not in the Attended data set. So that tells us we're going to do an anti-join. But we have to match this up by two fields, because notice. In the attended data set, we have Isobel Arnold. We have Raphael Arnold. And a bunch of duplicates. But then, near the bottom we have, Isobel La Croix. So in order to do this right, we have to merge using two fields. Let's do it. Put the cursor in a data set. Data, From Table/Range. Table does have headers. Want to call this, Attended. Okay. And then close and load this as a connection only. Only Create Connection, okay.…

Contents