Has anyone loaded data from IMF or EUROSTAT using their URL addresses?

[#1]

I would like help to link and load this table from Eurostat http://epp.eurostat.ec.europa.eu/tgm/table.do?tab=table&init=1&plugin=1&language=en&pcode=tec00115 from the URL rather than downloading the CSV or excel doc. It is so that I can refresh the data without having to do a download to obtain the latest version of the data every time.

I would like to be able to do this for any of the Eurostat and IMF statistics data contiained on the following sites http://epp.eurostat.ec.europa.eu/portal/page/portal/statistics/search_database & http://www.principalglobalindicators.org/default.aspx.

Ideally, I would also like to be able to automatically refresh the Eurostat bulkdownload from http://epp.eurostat.ec.europa.eu/portal/page/portal/statistics/bulk_download in Qlikview

Le t me know if I am barking up the wrong tree.

Stephen

[Gysbert_Wassenaar · Accepted solution]

For the first link you can try this:

Webdata:

LOAD @1 as Country, RecNo() as recno

FROM

[http://epp.eurostat.ec.europa.eu/tgm/table.do?tab=table&init=1&plugin=1&language=en&pcode=tec00115]

(html, codepage is 1252, no labels, table is @5);

join

LOAD

     RecNo() as recno,

     @1 as 2003,

     @2 as 2004,

     @3 as 2005,

     @4 as 2006,

     @5 as 2007,

     @6 as 2008,

     @7 as 2009,

     @8 as 2010,

     @9 as 2011,

     @10 as 2012,

     @11 as 2013,

     @12 as 2014

FROM

[http://epp.eurostat.ec.europa.eu/tgm/table.do?tab=table&init=1&plugin=1&language=en&pcode=tec00115]

(html, codepage is 1252, no labels, table is @6);

drop field recno;

The problem is that you need to manually construct such statements for each page. Such a page contains a number of tables since headers and data are in separate tables. If anything changes, ie @1 is no longer 2013 but 2014, you need to manually change the script again.

The bulk downloads are compressed file formats. Qlikview cannot extract data from such files. I'm afraid you'll have to find a more friendly tree.

[#3]

Thank you very much Gysbert.   Any thoughts for the third link on IMF data?

Ever so grateful.

Stephen