Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Using While or For Each in Load statement Tables

I have 360 tables in SQL and i need 250, how i can extract this tables using something like Do while, for each..
example

Load *;
C1,
C2,
C3...

from $t1 ;
...to $t250

thanks in advance

Tags (4)
1 Reply
swuehl
Not applicable

Using While or For Each in Load statement Tables

You may want to have a look at FOR...NEXT in the manual, probably something like following might work:

for counter=1 to 250 step 1

let tablename = '$t$(counter)';

load a,b from $(tablename);

next

Hope this helps,

Stefan