Question

In Power Query, you are enriching a Sales table with a RegionManager column. You merge Sales with a Region lookup table on the RegionID column. Every RegionID in Sales exists in the Region table, and each RegionID appears exactly once in the Region table. You want the merged result to keep every Sales row and add the matching manager, without accidentally increasing the row count. Which join kind should you configure in the Merge Queries dialog?

Accepted Answer

Left Outer (all from first, matching from second)

Answer

Full Outer (all rows from both)

Answer

Right Outer (all from second, matching from first)

Answer

Left Anti (rows only in first)