Surprising data sources

QlikView reads database tables, spreadsheets, XML files, and text files, but did you know that it can also take data from a web page? If you need some standard data from the Internet, there's no need to create your own version. Just grab it from a web page! How about ISO Country Codes? Here's an example.

Open the script and click on Web files… below Data from Files on the right-hand side of the bottom section of the screen. This will open the File Wizard: Source dialogue.

Enter the URL where the table of data resides:

Then, click on Next; in this case, choose @2 under Tables:

Click on Finish, and your script will look something similar to this:

LOAD F1, 
     Country, 
     A2, 
     A3, 
     Number
FROM
[http://www.airlineupdate.com/content_public/codes/misc_codes/icao_nat.htm]
(html, codepage is 1252, embedded labels, table is @2);

Now, you've got a great lookup table in about 30 seconds—and another few seconds to clean it up for your own...