Power QueryExercises

Appending tables quiz

Stacking tables and aligning their schemas.

Revise first: Append tables and align their columns, Append many tables and tag where each row came from, Mixed column types after an append, Control the appended schema

Question 1

1.What are the columns?

Table.ColumnNames(Table.Combine({#table({"A", "B"}, {{1, 2}}), #table({"A", "C"}, {{3, 4}})}))
Question 2

2.What does this return?

Table.Combine({#table({"A", "B"}, {{1, 2}}), #table({"A", "C"}, {{3, 4}})}){1}[B]
Question 3

3.How does Table.Combine match columns?

Question 4

4.One table calls the amount Total, the other Amount. What do you do before appending?

Question 5

5.What's the difference between append and merge?

Question 6

6.How many rows?

Table.RowCount(#table({"A"}, {{1}, {2}}) & #table({"A"}, {{3}}))
Question 7

7.Store rows don't have a Coupon column but web rows do. After appending, store rows show…

Question 8

8.You need to know which source each appended row came from. What's a simple approach?

0 of 8 answered. Unanswered questions count as wrong.