topic Re: how to implement incremental load with last modified date in loop? in QlikView

how to implement incremental load with last modified date in loop?

madhubabum — Fri, 15 Jan 2016 07:38:23 GMT

Hi Experts,

I am having the following updated data QVD's.

Name Last Updated on

Sales1.qvd Dec-15-2015

Sales2.qvd Dec-11-2015

Sales3.qvd Dec-20-2015

Here i want to implement incremental load..How we can implement ? (Please help to write script)

Note :Loading Order

Sales2.qvd

Sales1.qvd

Sales3.qvd

Regards

Madhu

Re: how to implement incremental load with last modified date in loop?

jagan — Fri, 15 Jan 2016 07:56:44 GMT

Hi,

If you are loading from QVDs I think there will be no change in the loading time, both Incremental and Normal load time is almost same. I think implementing the Incremental load makes script more complex here, specially it is used to load from database.

Regards,

Jagan.

Re: how to implement incremental load with last modified date in loop?

madhubabum — Fri, 15 Jan 2016 08:32:42 GMT

Hi jagan mohan rao,

Thanks for your reply

No, these files are having different time stamp

Name Last Updated on

Sales1.qvd(Oct-19-2015 06:12:30) Dec-15-2015

Sales2.qvd (Nov-10-2015 11:10:45) Dec-11-2015

Sales3.qvd (Dec-12-2015 10:23:25) Dec-20-2015

Re: how to implement incremental load with last modified date in loop?

Anonymous — Fri, 15 Jan 2016 08:43:30 GMT

may be Filetime() & QVDCreateTime() help you?

1) Load Sales QVds one by one

2) Store the Modified time of each with above functions

3) Then Compare stored time with each other qvds time

4) Finally call the Qvds with max timestamp with incremwntal load?