Loop

[#1]

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

[Anonymous]

Thomas,

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

Marc.

[sunny_talwar · Accepted solution]

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

next

HTH

Best,

S

[chrismarlow]

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