Power QueryExercises

Duplicates and keys quiz

Deduplicating on the right key, which row survives, and index columns.

Revise first: Remove duplicates on the right key, Add index columns, Check key quality before you rely on it, Choose which duplicate to keep with a business rule

Question 1

1.How many rows remain?

Table.RowCount(Table.Distinct(#table({"Email", "Src"}, {{"a@x", "Web"}, {"a@x", "Event"}, {"b@x", "Web"}})))
Question 2

2.How many rows remain?

Table.RowCount(Table.Distinct(#table({"Email", "Src"}, {{"a@x", "Web"}, {"a@x", "Event"}, {"b@x", "Web"}}), {"Email"}))
Question 3

3.What should you do before deduplicating on Email?

Question 4

4.What's a reliable way to keep each customer's latest record?

Question 5

5.What does this return?

Table.AddIndexColumn(#table({"X"}, {{"a"}, {"b"}}), "I", 1, 1)[I]
Question 6

6.You add an index and then sort. What does the index represent?

Question 7

7.What does this return?

Table.IsDistinct(#table({"K"}, {{1}, {2}, {1}}))
Question 8

8.Which rows count as duplicates for a mailing list?

0 of 8 answered. Unanswered questions count as wrong.