Discussion Board for collaboration on QlikView Scripting.
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.
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.
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 DayFROMD:\Tables\AmountTb.qvd (qvd);
RecordTb:LOAD contractid, id as recordid
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.
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.