Power QueryExercises

Module 18

Nested data and JSON

Expand records, lists and nested tables; flatten JSON.

You'll be able to

Lessons

  1. 1.Flatten nested JSONExpand records and lists in the right order to flatten JSON.
  2. 2.Expand record columns safely when fields varyExpand records with optional fields without losing new fields or failing on null.
  3. 3.List columns: expand to rows or extract valuesPick the right treatment for a column of lists for the table you need.
  4. 4.Reference other queries: staging and reuseStructure a workbook as staging queries plus output queries that reference them.

Take the nested data and json quiz (8 questions)

Exercises