Power QueryExercises

Module 11

Appending tables

Stack tables, align schemas and handle mismatched columns.

You'll be able to

Lessons

  1. 1.Append tables and align their columnsStack tables correctly, including ones whose column names differ.
  2. 2.Append many tables and tag where each row came fromCombine a list of tables while keeping each row traceable to its source.
  3. 3.Mixed column types after an appendDetect and repair columns whose values have different types after an append.
  4. 4.Control the appended schemaProduce the same set of columns from an append however the inputs vary.

Take the appending tables quiz (8 questions)

Exercises