Power QueryExercises

Merge

Power Query's join: matching rows of two tables on key columns and bringing matching rows across as a nested table.

A merge adds a column of nested tables containing the matching rows from the second table; you then expand the columns you need or aggregate them. The join kind decides which rows survive, and the keys must have the same type and clean values on both sides.

In the Power Query editor

Home → Merge Queries, which writes Table.NestedJoin followed by an expand step.

Learn more

Related functions

Practise it

Related terms