Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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?

bestofwest
Creator II
Creator II

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.

bestofwest
Creator II
Creator II

Process it before call Qlik.

Any Progamming language do the job easly.

Qlik is BI tool not a PL.