Power QueryExercises

Merging tables quiz

Join kinds, expansion, composite keys and join explosions.

Revise first: Merge queries: choosing a join kind, Merge on composite keys, Predict row counts: one-to-many and many-to-many merges, Expand or aggregate a merge result

Question 1

1.Which join keeps every order and adds the customer's city where known?

Question 2

2.Which join lists orders whose customer is missing from the master list?

Question 3

3.How many rows?

Table.RowCount(Table.NestedJoin(#table({"K"}, {{1}, {2}}), {"K"}, #table({"K", "V"}, {{1, "a"}, {1, "b"}}), {"K"}, "J", JoinKind.LeftOuter))
Question 4

4.How many rows after expanding?

Table.RowCount(Table.ExpandTableColumn(Table.NestedJoin(#table({"K"}, {{1}, {2}}), {"K"}, #table({"K", "V"}, {{1, "a"}, {1, "b"}}), {"K"}, "J", JoinKind.LeftOuter), "J", {"V"}))
Question 5

5.Prices depend on store and product. What key do you merge on?

Question 6

6.Your row count grew after a merge. What's the likely cause?

Question 7

7.How many rows?

Table.RowCount(Table.NestedJoin(#table({"K"}, {{1}, {2}, {3}}), {"K"}, #table({"K"}, {{2}}), {"K"}, "J", JoinKind.Inner))
Question 8

8.Why untick 'Use original column name as prefix' when expanding?

0 of 8 answered. Unanswered questions count as wrong.