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 purposes. One small caveat though...