Power QueryExercises

Join kind

Which rows a merge keeps: left outer, inner, left anti, right anti, full outer or right outer.

Left outer keeps every row of the first table, inner keeps only matches, anti joins keep only non-matches, and full outer keeps everything from both. Choosing the kind is a business decision: whether an order without a customer should appear in the report or be flagged.

In the Power Query editor

The Join Kind list at the bottom of the Merge dialog.

Learn more

Practise it

Related terms