New: Semi-Joins in Power Query + a Brief Overview of Power Query’s Outer and Inner Joins

Joins/Merges in Power Query are so useful but can be hard to understand. I’ve done videos on the Inner, Outer and Anti Joins.

Recently, Semi-Joins have been made available. Again: they can be tough to understand and see a reason for their use.

In this video you’ll see:
Intro: 0:00
Overview of Joins 0:23
Data Example 2:43
Inner Join 4:51
Semi Join 5:41
Outro 8:44

Basically:
If I have list A and list B
I want to know who is on both lists but I DO NOT want the data merged.

Examples for a Semi-Join:
– You have a list of actors and a list of movies with their details.
A semi-join can list the actors who appeared in the list of movies WITHOUT the movie details.
– You have a list of cars and a list of dealerships that have those cars.
A semi-join can reduce the list of cars to those that are available WITHOUT bringing over the dealership details.

#SemiJoin
#PowerQuery

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2