Power QueryExercises

Module 12

Merging (joining) tables

Join kinds, composite keys, expanding results and predicting row counts.

You'll be able to

Lessons

  1. 1.Merge queries: choosing a join kindPick the join kind that returns exactly the rows the question asks for.
  2. 2.Merge on composite keysJoin tables whose rows are identified by a combination of columns.
  3. 3.Predict row counts: one-to-many and many-to-many mergesKnow in advance how many rows a merge should produce and check it.
  4. 4.Expand or aggregate a merge resultChoose between expanding and aggregating nested merge results, and do both correctly.

Take the merging (joining) tables quiz (8 questions)

Exercises