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