Power QueryExercises

Module 15

Combining files and parameters

Combine folder-like file packs with one reusable transformation.

You'll be able to

Lessons

  1. 1.Combine files from a folderApply one parsing step to every file in a folder and stack the results.
  2. 2.Turn a sample-file transformation into a functionBuild and test a reusable file-parsing function, as Combine Files does.
  3. 3.Parameters: one value, many queriesReplace repeated hard-coded values with parameters that queries reference.
  4. 4.Combine files whose columns differCombine files with drifting schemas without losing columns or rows.

Take the combining files and parameters quiz (8 questions)

Exercises