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.

Left outer join

Left outer join

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

Start my 1-month free trial

Left outer join

“

- [Instructor] You and I are leading a new product orientation, and here's our list of people who are required to attend, and people who are enrolled. What we need now is for people who are required to attend, bring over their session. Lloyd is in customer service and we need to also see that Lloyd is signed up for Wednesday. To get this, we are going to do a left outer join. Here we go. Cursor in the data set, we got to make our queries. First of all, data, from table slash range. Here is our required query. I'm going to close and load this as a connection only. Only create connection. Okay. Now, the enrolled list, from table slash range, enrolled, and then close and load this as a connection only. Okay. Now, to do our merge, hit data, combine queries, merge, all right, put required up top, that's our left side, and then enrolled on the bottom, that's our right side, match up name, and name, leave this at the…

Contents