topic Re: Partial Reload From Server in QlikView

Partial Reload From Server

Anonymous — Thu, 31 May 2012 11:16:04 GMT

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.

Kind Regards

Razak

Partial Reload From Server

Thu, 31 May 2012 11:28:30 GMT

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

Partial Reload From Server

Anonymous — Thu, 31 May 2012 11:36:59 GMT

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

Re: Partial Reload From Server

Thu, 31 May 2012 11:57:06 GMT

Hi,

Please find the attachment, how to implement incrementatl loading.

Regards,

P.Prasath

Partial Reload From Server

Anonymous — Thu, 31 May 2012 12:17:16 GMT

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