In this type of table creation(Crosstable) try to create Resident table of that cross table.
CrossTable (Name, Data, 2)
// Problem starts here because of "crosstable"
1 AS Choice
(biff, embedded labels, header is 1 lines, table is Table1$);
1 as choice,
Drop Table Temp;
Hope this helps you.
@its.anandrjs your right,
i was thinking of the same solution, but im searching a way tor prevent those (load resident) steps.
If a larger amount of data is loaded like this, it will take some time.
because of the resident load inside qlickview (which is quite fast), this uses not so much cpu time as i expected.
but it uses a lot of ram, due to the double amount of data (500T+ datasets).
in case, someone has the same problem, here is how i solved this:
this can be handled by "pumping" the data month by month, so the amount of redundant datasets is reduced.
load data in "loader_table",
resident load + variables in "temp_a",
variables loaded as %name_a,
load * (as %name)
load next month
and so on
problem solved. thank you