Power Query - 6 Types of Joins, 6 Types of Merges - 9 Examples

Power Query - 6 Types of Joins, 6 Types of Merges - 9 Examples

ExcelIsFun via YouTube Direct link

) Left Outer Join to pull matching Multiple Records from the Right Table (One Lookup Value, Return Multiple Items).

10 of 14

10 of 14

) Left Outer Join to pull matching Multiple Records from the Right Table (One Lookup Value, Return Multiple Items).

Class Central Classrooms beta

YouTube playlists curated by Class Central.

Classroom Contents

Power Query - 6 Types of Joins, 6 Types of Merges - 9 Examples

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction.
  2. 2 ) Full Description of What A Join is and what a merge is. What is A Join?
  3. 3 ) Inner Join
  4. 4 ) Create Folders to organize Queries
  5. 5 ) Full Outer Join
  6. 6 ) Left Anti Join
  7. 7 ) Right Anti Join
  8. 8 ) Left Outer Join for Lookup
  9. 9 ) Left Outer Join for Two Value Lookup
  10. 10 ) Left Outer Join to pull matching Multiple Records from the Right Table (One Lookup Value, Return Multiple Items).
  11. 11 ) See how to use Expand Column to Aggregate Values.
  12. 12 ) Right Join Outer
  13. 13 ) Self-Join
  14. 14 ) Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.