topic Using While or For Each in Load statement Tables in QlikView

Using While or For Each in Load statement Tables

Mon, 31 Oct 2011 17:58:28 GMT

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

swuehl — Mon, 31 Oct 2011 20:44:40 GMT

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);

Hope this helps,

Stefan