topic Re: Load data from website in QlikView

Load data from website

vireshkolagimat — Tue, 10 May 2016 10:54:34 GMT

Hi Guys,

I have a URL like http://link.html and i tried to connect it to Qlikview thru Webfiles option.

But i am not able to see any tables in File Wizard Type and in preview it is showing as "Can not open the html file".

Please let me know what is wrong.

Than you!!!

Regards,

Viresh

Re: Load data from website

settu_periasamy — Wed, 11 May 2016 03:01:52 GMT

Have you checked is there any html table in that link?

below is just a sample for web load..

Directory;

LOAD Currency, 
     Rate
FROM
[http://www.xe.com/currencytables/]
(html, codepage is 1252, embedded labels, table is @1);

Re: Load data from website

Anonymous — Wed, 11 May 2016 03:22:50 GMT

Hi Viresh,

It seems an access issue, I've gotten that type of error when trying to access Google Spreadsheets and the file is only open to an specific group of people.

Regards,

-- Karla

Re: Load data from website

vireshkolagimat — Wed, 11 May 2016 10:53:54 GMT

Hi, thanks, i will check.

Re: Load data from website

vireshkolagimat — Wed, 11 May 2016 10:58:30 GMT

Hi ,

I tried to load some data from google and it is working fine.

http://www.infoplease.com/world/statistics/most-populous-countries.html

Regards,

Viresh