Power QueryExercises

Nested data and JSON quiz

Records, lists and expanding JSON into flat tables.

Revise first: Flatten nested JSON, Expand record columns safely when fields vary, List columns: expand to rows or extract values, Reference other queries: staging and reuse

Question 1

1.How does Json.Document represent a JSON object?

Question 2

2.Expanding a list column does what?

Question 3

3.What does this return?

Json.Document("[1, 2, 3]"){2}
Question 4

4.How many rows?

Table.RowCount(Table.ExpandListColumn(#table({"Id", "L"}, {{1, {"a", "b"}}, {2, {"c"}}}), "L"))
Question 5

5.What are the columns?

Table.ColumnNames(Table.ExpandRecordColumn(#table({"Id", "R"}, {{1, [a = 1, b = 2]}}), "R", {"a", "b"}))
Question 6

6.An order has a list of lines and a list of payments. Expanding both in one table gives…

Question 7

7.What does this return?

Json.Document("{""a"": {""b"": 5}}")[a][b]
Question 8

8.An order's JSON has a lines array of objects such as {"sku": "A1", "qty": 2}. After expanding lines into rows, each row's lines value is…

0 of 8 answered. Unanswered questions count as wrong.