Power QueryExercises

Composite key

A key made of several columns that together identify a row, such as Store + Product for a price list.

When one column alone isn't unique, matching on several columns together gives a unique key. In the Merge dialog, select the key columns in the same order in both tables. Cleaning every part of the key (trim, case, type) matters as much as with a single key.

In the Power Query editor

Ctrl+click several columns in each table of the Merge dialog; the numbers show which columns pair up.

Learn more

Practise it

Related terms