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

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

Fri, 10 May 2013 08:56:19 GMT

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

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

Gysbert_Wassenaar — Fri, 10 May 2013 09:35:52 GMT

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.

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

Fri, 10 May 2013 11:35:03 GMT

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

Ever so grateful.

Stephen