Looping data load

saxofonoacn — Tue, 24 Nov 2015 15:42:13 GMT

Hi guys,

I am trying to loop a data load into a qvd level; however having problems...

The data comes from .html files titles 2001.html to 2265.html but some are missing so all in all 187 HTML files. One is GDP, other one Population and so on...
I am trying to loop over "@[number]" tables where each @ is a new country (therefore F1 is "Country" field@) and F2 is a measure with data (say GDP). The number of tables @1, @2.... can go up to hundreds and I don't know at any point how many tables there are (as per pic below). @4 gives headings: Country, [names measure] (I am not interested in @1 to @3 but that's a detail).

Q1: how to do the loop so each country is loaded with all measures (from all files) and data for that measure.

Q2: data for the measure sometimes contains multiple figures for different years (see picture). Subfield () would be the obvious first thing to do here, but if you have any other/ better ideas, I am listening

2001.html give the following for GDP:

2002.html gives Population growth in %:

Thank you in advance!

Re: Looping data load

Gysbert_Wassenaar — Thu, 26 Nov 2015 09:31:08 GMT

Q1: Perhaps this discussion helps: know the number of tables

Q2: Subfield() looks logical. Perhaps Mid() could be used too if the strings are fixed length (including padding spaces).

Re: Looping data load

saxofonoacn — Mon, 30 Nov 2015 11:54:49 GMT

Thanks Gysbert Wassenaar. In addition, I created another loop but the main load is done more or less the way you suggested. Very helpful!!

topic Looping data load in QlikView

Looping data load

Re: Looping data load

Re: Looping data load