topic Re: Loop inside a Load in QlikView

Loop inside a Load

luke1986 — Fri, 24 Jul 2015 08:49:25 GMT

Hello,

Iam trying to Loop inside a Load until it has reached a specific number.

Because i have a table with a lot of Columns (Artikel.L1 --> Artikel.L20)

So basically this is what i have tried,

for i=1 to 20

LOAD

Key&'-'&Artikel.L$(i) as Artikel$(i)

Resident FullTree;

Next i;

It generate seperate Tables for every step.

but i want them in one single Table. How do i achieve this?

Thanks for your help!

Re: Loop inside a Load

swuehl — Fri, 24 Jul 2015 08:51:16 GMT

for i=1 to 20

IF i > 1 THEN

CONCATENATE

ENDIF

LOAD

Key&'-'&Artikel.L$(i) as Artikel$(i)

Resident FullTree;

Next i;

Re: Loop inside a Load

pokassov — Fri, 24 Jul 2015 08:51:56 GMT

for i=1 to 20

if i=1 then

table1:

LOAD

Key&'-'&Artikel.L$(i) as Artikel$(i)

Resident FullTree;

else

concatenate (table1)

LOAD

Key&'-'&Artikel.L$(i) as Artikel$(i)

Resident FullTree;

end if;

Next i;

Re: Loop inside a Load

alexandros17 — Fri, 24 Jul 2015 08:54:27 GMT

solution 1:

MyTab:

Select '' as fld1 .... '' as fldn;

For i=1 to 20

concatenate (MyTab)

Load ....

solution 2:

For i=1 to 20

myTab_$(i)

Load ....

For i=1 to 20

load ... resident myTab_$(i);

let me know

Re: Loop inside a Load

luke1986 — Fri, 24 Jul 2015 09:09:30 GMT

Thanks Sergey,

It worked!