Loop table and Crosstable? It is possible?

Mon, 24 Jun 2013 11:20:40 GMT

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.

Re: Loop table and Crosstable? It is possible?

Gysbert_Wassenaar — Mon, 24 Jun 2013 11:31:46 GMT

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...

Result:

crosstable(Key,Value)

load * resident Temp;