Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
scottduthie
Partner Ambassador
Partner Ambassador

Loading Web Files

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:

1.png

0 Replies