topic Load Data from Website - HTML-Table in QlikView

Load Data from Website - HTML-Table

Tue, 01 Nov 2011 17:01:07 GMT

I need to load the IATA Airline Codes from a website which provides the data in a HTML-Table.

It is possible to load these data from this webside using Qlikview script? I tried the Script-Wizard using Web files, but this will not work.

Example: http://www.airlineupdate.com/content_public/codes/airportcodes/airport_iatacodes/iata_a.htm

I need the table with the IATA Code, ICAO, Airport, City, Country.

The Wizard Webfiles is not showing me the website or loading anything, Qlikview is stuck and need to restart after loading this website.

Thanks in advanced, Thomas

Load Data from Website - HTML-Table

rrsrini2907 — Tue, 01 Nov 2011 17:26:33 GMT

Please check again.

I Can able to pull data from the above link.

It has got 521 records.

Regards,

Srini.

Re: Load Data from Website - HTML-Table

llauses243 — Wed, 02 Nov 2011 01:41:30 GMT

Hi,

This is my offer, pls to see image attached

Good lck, Luis

Re: Load Data from Website - HTML-Table

Wed, 02 Nov 2011 20:28:21 GMT

Thank you.

It seems that QlikView is using the Internet Explorer Settings to access the internet. I opened the website with Opera but QV is using a different setting for Internet. Unfortunately QV crashes completely when it cannot open the website (i.e. wrong proxy).

It is possible to use another setting for internet in QV? Like Opera does.