Loop table and Crosstable? It is possible?

[#1]

Hello everybody.

It is possible to load a formated table to link with a loop in the script.

I have a ExcelTable with 52 sheets, For every week one sheet. So I must work with the control statement for and next.

Is the cross table is loaded without loop  it works. If I load the crosstable with the loop the load has a failure.

See also the added example.

Please help! Thanks

greetings Sven

[Gysbert_Wassenaar]

First load all the data in a table using the loop and then create a new table using the crosstable function. Something like:

for i=1 to 52

Temp:

load * from ...excelfile...

next

Result:

crosstable(Key,Value)

load * resident Temp;