Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Attached is our QVD Gen from one of our support team , which is some how complicated (Use of variables).
I have tried few things in order to do incremental load on generated qvd's , but failed to do so.
Currently I believe this is doing full load in each trigger and storing qvd's. See below:
I'm looking for a solution where I can do incremental load on generated qvds, can't wait for 2 hours for new data.
I tried so many things based on comments from developer at script side , but still no success .
Please suggest what is the best possible way for incremental load.
Thanks,
AS
any suggestions???
Thanks,
AS
Hi Amit, Your script looks OK, havent look so deep into it but should work. The most important is that DTUPDATE and Last_Updated_Date is in exactly same format otherwise it will do a full reload.
Save on another QVD the last date. Filter new data with this date and load the last QVD filtering date. Store all table on the new QVD.
Kind regards
Staffan,
Thanks for the input!
I have asked for the DTUPDATE format to database admin.
Thanks,
AS
Hi Bro,
I don't have QlikView in my system to look into your application, but can you just give me an overview what issue you are facing currently?
Hi Kush,
Attached is script for qvd generator , the issue is every time this is doing full load , I want to do Incremental load .
Thanks,
AS
Can you tell me what is the value you are getting in variable "Last_Updated_Date"?
Sorry but can't see this variable in list
But LastExecTime is having below value:
Thanks,
AS