Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mambi
Creator III
Creator III

Loading Data from web page

Hello everyone,

I'm using QV11 desktop and I'm trying to load data from a simple web page (Table) : List of countries by motor vehicle production - Wikipedia

but i got this error : Internet error 12157

i assume it's an error related to the https

any one have an idea on how to solve this problem ?

Thanks

11 Replies
avinashelite

it not the error related to QV check this

How to resolve internet errors 12157/12057/12045?

mambi
Creator III
Creator III
Author

but when I try with an other site without https it's works

avinashelite

It depends on the site security features ...did you tried as per the above article ? did the issue got resolved ?

mambi
Creator III
Creator III
Author

I haven't  found a real solution in this article

adamdavi3s
Master
Master

This runs absolutely fine for me which suggests it must be something to do with your network I guess:

LOAD Rank,

     Country,

     "2015 [2]",

     "2014 [3]",

     "2013 [4]",

     "2012 [5]",

     "2011 [6][7]",

     "2010 [7][8]",

     "2005 [9]",

     "2000 [10][11]",

     "1995 [11][12]",

     "1990 [13][14][15]",

     "1980 [13][14][15][16]",

     "1970 [13][14][15][16]",

     "1960 [13][14][15][16]",

     "1950 [13][14]",

     "Peak production [13][14][11][17][12][15]",

     "Peak year [13][14][11][17][12][15]"

FROM

[https://en.wikipedia.org/wiki/List_of_countries_by_motor_vehicle_production]

(html, codepage is 1252, embedded labels, table is @1);

mambi
Creator III
Creator III
Author

if I use your script I got this error : img.jpeg

adamdavi3s
Master
Master

loading locally or loading from the server?

where ever you're loading from, can you access that page in I.E.?

mambi
Creator III
Creator III
Author

I'm loading locally,

your are right I can't access this page from IE

adamdavi3s
Master
Master

I suspected that would be the case, its some network issue then I am afraid