Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental reload

Hi,

I have a QlikView application which loads the data from a
oracle database...

SELECT * FROM DB."DATE_DIMENSION";

Is there a way to do an incremental update of the data (only reload new data)
without loading the entire data of the db.

How is it possible...?

62 Replies
Not applicable
Author

Hi Rob,

Can you please attach any sample application which does he incremental load please.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP


Rikab Kothari wrote:Can you please attach any sample application which does he incremental load please.


There is an example in the Qlikview Cookbook.

-Rob

neetu_singh
Partner - Creator III
Partner - Creator III

Hi Rob,

Here is the attached application for incremental load. plz find it.

Hope it will solve your problem.

Thanks

Neetu Singh

Not applicable
Author

Hi Neetu,

It was not Rob. It was me who was looking for the incremental reload.

Anyway many thanks for sending me the application. Hope it is understandable and can use the same logic in my document. Because I have few document which does the incremental load but I couldn't understand how it was done. Hope your document will be understandable.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP


Rikab Kothari wrote: It was me who was looking for the incremental reload


Hi Rikab,

There is another example in the Qlikview Cookbook that takes a slightly different approach then Neetu's example. You can download the Cookbook from

http://robwunderlich.com/Download.html

-Rob

Not applicable
Author

Hi Rob,

Thanks for reply! Yes I already gone through that. But not able to understand how it works. If I don't understand then it not easy to apply the same logic in my document also.

May be I need to dig little deeper to find out how exactly it is happening there. I will definitely go through it once more then will let you know the outcome. Again many thanks for your concern!

Not applicable
Author

Hi Rob and All(Who are all is involved in this post),

I have attached very basic document to work on with incremental load. Can some one please do the incremental load with that so that I can understand the basic things in that.

It is very small and it will not take much time to work on it.

Hope to receive reply from some one soon.

Not applicable
Author

Hi All,

Can some one please work on in my document and help me out!

Thanks and Regards,

Rikab Kothari

Not applicable
Author

Hi All,

Can some please help me out to do the incremental load for the document which is attached just for the understanding purpose. I have been waiting for the long time but still there is no response.

neetu_singh
Partner - Creator III
Partner - Creator III

Hi Rikab,

Please find the attached application for incremental load. hope it will helpful to you.

If any issue . Plz feel free to coordinate with me,

Bye nd Take Care

Neetu Singh