Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

FOR ... NEXT + DO while LOOP

Hi All,

I'm loading web data from several links. It happens that a request returns no data (supposedly web server issues) but if requested again it does return the data. I need to implement DO while LOOP into the below code so that when the requests returns no data the loop requests again until it gets the data. I've tried with FieldValue but ended up with errors. Any help will be much appreciated.

Links:

LOAD * Inline [

http://www.rates1.com

http://www.rates2.com

http://www.rates3.com

];

Rates:

LET vNoOfLinks = NoOfRows('Links');

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

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

LOAD

  [@1:n] as Data

FROM $(vLink) (fix, utf8);

NEXT

Regards,

Przemek

12 Replies
Not applicable
Author

Well, there are many reasons but the bottom line is that it's comfortable to get and process the data in QV. What would suggest otherwise?

Anonymous
Not applicable
Author

On Qlik You should use the Edit only for some configuration definition and load /join of data structures.

The read/load of URL files inside qlik is not recommended for many reasons - performance is the main reason.

Generate a file, csv, a table, a qvx or better a qvd outside qlik is the best solution.

Anonymous
Not applicable
Author

Process it before call Qlik.

Any Progamming language do the job easly.

Qlik is BI tool not a PL.