Power QueryExercises

Combining files quiz

Combining folder files with one transformation and keeping the file name.

Revise first: Combine files from a folder, Turn a sample-file transformation into a function, Parameters: one value, many queries, Combine files whose columns differ

Question 1

1.What does a folder source give you?

Question 2

2.How is a new file added next month handled?

Question 3

3.Why keep the Name column when combining?

Question 4

4.One file has an extra column. What happens when you expand with a fixed column list?

Question 5

5.A stray readme.txt sits in the folder. What's a good safeguard?

Question 6

6.What does Combine Files generate in Excel and Power BI?

Question 7

7.Each file must share what for combining to be reliable?

Question 8

8.How many rows?

Table.RowCount(Table.Combine({#table({"A"}, {{1}, {2}}), #table({"A"}, {{3}}), #table({"A"}, {{4}, {5}})}))
0 of 8 answered. Unanswered questions count as wrong.