I am creating QVD for the first time, where do i write store command ?
beginning of the load statement or after the select statement ?currently i have it as below and when i save and reload the scripts it is fetching the records.
Actually the reson for me creating QVD is , my table has got more than 10 million records, whenever i reload the scripts after fetching some 2 million rows i get an error message saying out of virtual memery , so someone said that these kind of issues can be handled by a QVD,
But here this even started fetching the rows ? i know eventually even this says out of memory ....
How do i handle this?
DW_T_JOBDATA:
LOAD DATE(FLOOR(FINISH_TIME)) AS FINISH_DATE, YEAR(FINISH_TIME) AS YEAR, MONTH(FINISH_TIME) AS MONTH, DAY(FINISH_TIME) AS [DAY];
SQL SELECT * FROM PIOWNER."DW_T_JOBDATA" where FINISH_TIME > SYSDATE - 30 ;
STORE DW_T_JOBDATA into \\qlikview\PDS Data\my forlder\DW_T_JOBDATA.QVD;
But if you get an error about out of virtual memory, that I think that you have a little physical memory. So you should add memory or share LOAD statement on some different parts. For example, you should load data by YEAR and store it in different QVD files.
But if you get an error about out of virtual memory, that I think that you have a little physical memory. So you should add memory or share LOAD statement on some different parts. For example, you should load data by YEAR and store it in different QVD files.
So how do i get multiple QVD's into one Qlikview file. I have multiple Clusters data , i think i will get each cluster data with one QVD, can i have a filter on all cluster in the QVW i get data into??
