Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;