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.
Enter the URL where the table of data resides:
Then, click on Next; in this case, choose @2 under Tables:
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...