topic Re: Incremental load in QlikView

Incremental load

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All ,

PLease find the attachment of the QVW file and QVD file..

Scenarion : Data will be fetched every 12 hours ... Every tweleve hours some new recods will be cnahged or updated.

If i use the Last updated peek of load date then i dont know how will it work because i need to add the changes records also

and this changes will be made twice in the same date .

How can i add insert and update only incremental load to this ?

Can someone please help me on this ?

Thanks and regads

krishna20 — Tue, 29 May 2018 06:58:07 GMT

Hi John,

I made necessary changes in the shared qvw.

Regards

Krishna

smilingjohn — Tue, 29 May 2018 07:13:04 GMT

Hi Krishna,

THnaks for the reply..

I have a doubt here ....

you are considering the max(load_Date) ... my question is .th data will be loaded two times within the same date (twice in 12 hours) ..

How will this recognise the changes being made or new recods being updated ?

Thanks

krishna20 — Tue, 29 May 2018 07:56:13 GMT

Hi,

PFA, done changes only for Insert and update.

Regards

Krishna

krishna20 — Tue, 29 May 2018 08:35:39 GMT

Attachment missed.