Hi, In the 7-2 review, I was able to load all 3 countries (uk, australia, and usa) in the query, however when I added new country like "japan" I received an error message as in the attachment 1. What do I need to do to fix this message? I also tried with another country "south-korea" and received the same. I only added the two countries in the first sheet below the table you had. please see attachment 2.
Hi Junko,
The query is looking for a column on the web page called 'Details'. If you look at the page for Australia you can see there are 4 columns, the last is called 'Details'. However, if you look at the web page for Japan you'll see there is no column for Details.
You can just remove the code {"Details", type text} from the '#'Changed Type" step in the Advanced Editor and the query will work for both Japan and Australia.
Mynda