Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have error: Out of virtual and/or logial memory 2 MB when downloaded data. RAM: 32 gB, processor: 4. QlikView are used 5 gB of RAM.
Number of rows are approximately 50 million.
I rewrited script in several view and it didn't help. I don't understand where is problem. Thank's for any help.
Following script:
AmountTb:
LOAD amount,Hi
Here inner join will not work.
QV support innerjoin by default,
here you can use left join if needed. as i don't think u need any join.
bcz conractid is only one field on that base both two tables get joined and buil data model.
Hi,
thanks a lot for your answer.
I rewrited script:
AmountTb:
LOAD amount,
typeid as amounttype,
recordid,
CurrencyId,
Inserted as aminsert,
month (Inserted) as Month,
Year (Inserted) as Year,
Day (Inserted) as Day
FROM
D:\Tables\AmountTb.qvd (qvd);
RecordTb:
LOAD contractid,
id as recordid
FROM
D:\Tables\RecordTb.qvd (qvd);
But it doesn't work on whole data base. When I checked on limitation data it was working. But when I want to upload all data QlikView returned error: Out of virtual and/or logial memory 2 MB.
Hi
Plz go through the test application i attached. here is ur solution..
bcz this error comes only when
* Bad DataModeling
Join the data table carefully.
Thanks
Ajeet