Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I am trying to loop a data load into a qvd level; however having problems...
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!
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).
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).
Thanks Gysbert Wassenaar. In addition, I created another loop but the main load is done more or less the way you suggested. Very helpful!!