Chapter 4, exercise 4-3

Niels
Book Q&A › Category: Chapter 4 › Chapter 4, exercise 4-3
0
Vote Up
Vote Down
Niels asked 4 years ago

After completing this exercise, I found it strange that both in my file as the solution file the column "list price" only contained values for the accessoires parent category.

I think this is caused by the value in cell E1 of C04E03 – Accessories.xlsx from the freshly downloaded zipfile on https://www.microsoftpressstore.com/store/collect-combine-and-transform-data-using-power-query-9781509307951

This cell contains a space before the underscore, if you remove it and refresh the query, the column is filled for all categories.

1 Answers
0
Vote Up
Vote Down

Best Answer

Gil Raviv Staff answered 4 years ago

Hi Niels,

You are correct. We will update the relevant file C04E03 – Accessories.xlsx soon. This is a great example for the challenges of mismatched columns 🙂

Thanks,

Gil