The 6 Joins in Power Query: Explained

You’ve seen the Joins in other videos, but here is a fun overview of all 6 joins in Excel’s Get & Transform (Power Query)

TIMELINE
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

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *