Chapter 4, exercise 4-3

Book Q&ACategory: Chapter 4Chapter 4, exercise 4-3
Niels asked 5 months 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
Best Answer
Gil Raviv Staff answered 5 months 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