Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

Incremental load help for QVD Gen

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

29 Replies
amit_saini
Master III
Master III
Author

any suggestions???

Thanks,

AS

amit_saini
Master III
Master III
Author

kush141087

jagan

Please help!

Thanks,

AS

stabben23
Partner - Master
Partner - Master

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.

Anonymous
Not applicable

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

amit_saini
Master III
Master III
Author

Staffan,

Thanks for the input!

I have asked for the DTUPDATE format to database admin.

Thanks,

AS

Kushal_Chawda

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?

amit_saini
Master III
Master III
Author

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

Kushal_Chawda

Can you tell me what is the value you are getting in variable "Last_Updated_Date"?

amit_saini
Master III
Master III
Author

Sorry but can't see this variable in list

But LastExecTime  is having below value:

Thanks,

AS