Loading Web Files

scottduthie — Tue, 25 Oct 2016 10:46:10 GMT

Hi Everyone,

I am trying to load a web file and I need to loop through my code to load 30 pages, which is effectively 30 different urls. I understand variables do not expand when dealing with web files in Qlik Sense and that you can set StandardReload=0, however this is still not working for me. When I open the Settings.ini file it is empty and I have simply added 'StandardReload=0', saved the file and restarted my computer.

Am I going about this the right way?

My script looks something like the following........

Let vLoopStart = 60037 ;

Let vLoopEnd = 60067 ;

for z = $(vLoopStart) to $(vLoopEnd)

Let var_Num = Text($(z)) ;

Temp_Table:

NoConcatenate

LOAD

FIELD_1,

FIELD_2,

FROM

[https://MY_WEBSITE...........php?recId='$(var_Num)']

(html, codepage is 1252, embedded labels, table is @1);

This is the error message I receive:

topic Loading Web Files in App Development

Loading Web Files