Chapter 4, exercise 4-3

Book Q&ACategory: Chapter 4Chapter 4, exercise 4-3
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

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 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 🙂