Discussion board where members can get started with QlikView.
i was trying to add a variable (1 AS Choice) to a crosstable loaded excel file
CrossTable (Name, Data, 2)
// Problem starts here because of "crosstable"
1 AS Choice
(biff, embedded labels, header is 1 lines, table is Table1$);
"Choice" is simply added to "Name", Like Adam, Bernard, Charly, Choice
Is there another way, to add a variable while loading with crosstable ?
Go to Solution.
In this type of table creation(Crosstable) try to create Resident table of that cross table.
1 AS Choice
1 as choice,
Drop Table Temp;
Hope this helps you.
1 as Choice
- Try this may be it 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