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

) Right Anti Join

7 of 14

7 of 14

) Right Anti Join

Class Central Classrooms beta

YouTube videos 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.