Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

dseelam
Contributor

Only Updated data

Hello All,

I am working on incremental loads on a view from oracle everything is working fine, Now I got a requirement asking to store history for that view , So I am storing a separate QVD for each day but hear am having a trouble duration of reload process became very slow as it is incrementing for each day and storing in separate QVD'S (IT HAS TO * ALL THE QVD'S for each day When incrementing) you can see in below picture how it is incremnting for each day

Is there any way that I can store the QVD's after 1st day only with incremental records instead of everything ??

Test3.PNG

Duration increase

Capture.PNG

Thanks,

Dinesh

2 Replies
vishsaggi
Esteemed Contributor III

Re: Only Updated data

Read this and try ? If not can you share your script to look into?

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

dseelam
Contributor

Re: Only Updated data

Hello Nag,

Thanks for replying my question is not about incremental load, It is about how to track history with incremental load ??