Forum

7-3 Received Error ...
 
Notifications
Clear all

7-3 Received Error for adding new country in "GetHolidays"

2 Posts
2 Users
0 Reactions
75 Views
(@nd09689)
Posts: 23
Trusted Member
Topic starter
 

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. 7_2_error_when_new_data_inputted1.PNG7-2_added_new_countries_sheet1.PNG

 
Posted : 09/06/2019 9:24 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 09/06/2019 7:15 pm
Share: