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.
Right outer join
From the course: Excel: Power Query (Get & Transform) (2020)
Right outer join
- [Instructor] You and I are hosting a new product orientation. And we want to take all of our enrolled people, and get their department names, for those who have enrolled, their department names are over in the required to attend data set. So we're looking at Nisha, who signed up for Wednesday, we want to pull over that she is in customer service. To get this matched up, we are going to do a right outer join. Cursor in the data set, you know it, from table slash range. This is our required query. Close and load it. Only create connection, okay. Next, cursor in the enrolled data set, from table slash range. Now I've got the data set here, now I'm going to combine, I'm going to merge queries, merge them as new, up top are my left side. I want required and then, enrolled. Match up name and name. We're doing a right outer join. Click okay. The left side is expanded. Our right side is collapsed. Let's expand it.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
Overview of joins in Power Query3m 11s
-
Full outer join4m 3s
-
Inner join2m 18s
-
Left anti join3m 2s
-
Right anti join2m 31s
-
Left outer join1m 58s
-
Right outer join2m
-
Outer join versus VLOOKUP2m 54s
-
Merge with multiple fields3m 4s
-
Joins: Left or right2m 13s
-
Approximate match equivalent of VLOOKUP: Binning2m 38s
-
Approximate match equivalent of VLOOKUP: Conditional column2m 31s
-
-
-
-
-