Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 [
];
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
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?
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.
Process it before call Qlik.
Any Progamming language do the job easly.
Qlik is BI tool not a PL.