topic Loop in QlikView

Loop

Mon, 02 Mar 2015 13:41:00 GMT

Hey,

why this one will not work?

Zahlen0:
LOAD * INLINE [
Zahl, Wert
1, 10
2, 20
3, 30
];

for vi=1 to 3

let vj = $(vi)-1;

Zahlen$(vi):
LOAD *
Resident Zahlen$(vj);

drop table Zahlen$(vj);

next

Thankjs

Re: Loop

Anonymous — Mon, 02 Mar 2015 13:46:32 GMT

Thomas,

Work / nor work depends on your requirements. Please explain it.

Marc.

Re: Loop

sunny_talwar — Mon, 02 Mar 2015 13:51:21 GMT

You need a NoConcatenate

Zahlen0:

LOAD * INLINE [

Zahl, Wert

1, 10

2, 20

3, 30

];

for vi=1 to 3

let vj = $(vi)-1;

Zahlen$(vi):

NoConcatenate

LOAD *

Resident Zahlen$(vj);

drop table Zahlen$(vj);

HTH

Best,

Re: Loop

chrismarlow — Mon, 02 Mar 2015 13:51:49 GMT

Do you not need to force it not to concatenate using NoConcatenate as the field names are the same to on the tables?