Merging Data with the 6 Joins in Power Query: Inner Join, Outer Joins and Anti-Joins Explained

You've seen the Power Query Joins in other videos, but here is a fun overview of all 6 joins in Excel's Get & Transform (Power Query) TIMELINE 0:00 Intro 2:39 Creating Queries 3:47 Full Outer Join 6:00 Left Outer Join 7:18 Right Outer Join 8:45 Inner Join 9:51 Right Anti Join 11:24 Left Anti Join 13:06 Something Crazy Here's my Intro to Power Query course at Lynda.com: https://www.lynda.com/Excel-tutorials... Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analy... My old blog: http://datascopic.net/blog-2-2 #6JoinsInPowerQuery #MergeTablesWithPowerQuery #PowerQueryJoinsExplained