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.

Walk through all six joins

Walk through all six joins - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Walk through all six joins

“

Let's step through the six joins that we find in the Power Query interface. These help us when we need to merge data, compare datasets, pill datasets apart. We've got two datasets. On the left side, we've got the people who RSVP'd, how they registered, and the session that they registered for. On the right side, we have the people who attended and the sessions that they attended. Angus registered online for the morning session, but Angus is not in the attended list. Jaye attended the afternoon session, but Jaye didn't RSVP. Jaye is one of our walk-ins. Lakeshia mailed in her registration for the morning session, but Lakeshia actually attended the afternoon session. All right. Let's look further into this stuff so that it's easier to see when we do the joins. First, we need our queries. Cursor is in this dataset. Right-click, GetData from Table/Range, table has headers. I'm going to call this one RSVP. And I'm going to close and load this as a connection only. Close and load to only…

Contents