Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amit_saini
Honored Contributor 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
Honored Contributor III

Re: Incremental load help for QVD Gen

any suggestions???

Thanks,

AS

amit_saini
Honored Contributor III

Re: Incremental load help for QVD Gen

kush141087

jagan

Please help!

Thanks,

AS

stabben23
Honored Contributor

Re: Incremental load help for QVD Gen

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.

manucamon
Valued Contributor III

Re: Incremental load help for QVD Gen

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
Honored Contributor III

Re: Incremental load help for QVD Gen

Staffan,

Thanks for the input!

I have asked for the DTUPDATE format to database admin.

Thanks,

AS

Re: Incremental load help for QVD Gen

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
Honored Contributor III

Re: Incremental load help for QVD Gen

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

Re: Incremental load help for QVD Gen

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

amit_saini
Honored Contributor III

Re: Incremental load help for QVD Gen

Sorry but can't see this variable in list

But LastExecTime  is having below value:

Thanks,

AS

Community Browser