FOR ... NEXT and DO until - part II

Tue, 02 Dec 2014 10:42:59 GMT

Hi All,

with a help from Marco Wedel (thread) I got the below script which requests data from websites in a loop until the data is loaded (due to web server issues a load ends up with no data so needs to be loaded again). Now I need to tune the script as described below.

Links:

LOAD * Inline [

Link

http://www.rates1.com

http://www.rates2.com

];

LET vNoOfLinks = NoOfRows('Links');

FOR i=0 to $(vNoOfLinks)-1;

LET vLink = Peek('Link',$(i),'Links');

LET vNoOfRowsRates = Alt(NoOfRows('Rates'),0);

DO

Rates:

LOAD

[@1:n] as Data

FROM $(vLink) (fix, utf8);

LOOP until NoOfRows('Rates') > $(vNoOfRowsRates);

NEXT;

Table 'Rates' consists of sets of data from Links. Each Link set (except the last one) should have exactly 10 records including '*increase*' string. However, due to web server issue, a load from a Link happens to return less than 10 records with the string. In such cases I need to load the data again from this very Link. The last Link set may return less than 10 records and that's ok.

Any idea how to play this scenario?

Regards,

Przemek

Re: FOR ... NEXT and DO until - part II

Wed, 10 Dec 2014 21:16:07 GMT

Anyone any idea, please?

topic FOR ... NEXT and DO until - part II in QlikView

FOR ... NEXT and DO until - part II

Re: FOR ... NEXT and DO until - part II