Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Partial Reload From Server

Hi,

Is it possible to do a partial reload from the server, I cannot find this option, we have millions of rows and we are planning on reloading everyday, we just want to add new data to the Qlikview Model  . I know how to do a partial reload from the Qlikview Desktop, but I want to automate it on the server.

Capture.PNG

Kind Regards

Razak

4 Replies
Not applicable
Author

Hi,

Try to implement incremental loading in your application,

this will fetch the updated records depending on the transaction dates and update to the existing qvd.

Regards,

P.Prasath

Anonymous
Not applicable
Author

Hi,

Could you please explain incremental loading?

Could you please use an example script,

This is what I use for a partial reload:

LOAD

     Date,

     Value

FROM TableX

ADD

LOAD

     Date,

     Value

FROM TableX

Where Date= TodaysDate

Which works when you do a partial reload,

How do I convert this to load incrementally?

Kind Regards

Razak

Not applicable
Author

Hi,

Please find the attachment, how to implement incrementatl loading.

Regards,

P.Prasath

Anonymous
Not applicable
Author

Hi,

From my understanding after reading the document, you will still have to load the previous data from  a QVD(which is better and faster)...Correct???

Kind Regards

Razak