topic Re: Incremental Load in QlikView

Incremental Load

Anonymous — Tue, 15 Jul 2014 06:11:11 GMT

How to do incremental load? Can anyone send me nice example to understand it. I am new to qlikview.

Thanks in Advance.....

Re: Incremental Load

its_anandrjs — Tue, 15 Jul 2014 06:18:27 GMT

There are so many best examples related to the Incremental load in the Community you can refer that

One of them from example

Re: Incremental Load

Anonymous — Tue, 15 Jul 2014 06:27:59 GMT

Thank u anand....

Re: Incremental Load

rido1421 — Tue, 15 Jul 2014 06:29:35 GMT

Hi Venkat

What would you like to Achieve with your incremental load.

what data source will you be extracting from?

[

Re: Incremental Load

Anonymous — Tue, 15 Jul 2014 06:34:39 GMT

Hi Rido,

I just want to know how to do incremental load in qlikview with nice example...i am not using any data source if u provide any excel data(to understand well)that would be great for me....

thanks in advance...

Re: Incremental Load

rido1421 — Tue, 15 Jul 2014 07:20:51 GMT

Hi Venkat

if you have a scheduled a model to extract data from a database on a daily bases this could help you understand.

If you create the qvd 1st with one days data in it then apply the logic of the concatenate,

it will add data everyday to the qvd, this would be a form of an "Insert" incremental load.

there are many ways to do this though.

[TableName]

Select Name,

branch,

ID.

Date

Where Date >= substr(to_char(trunc(sysdate)-1,'yyyymmdd')) ;

Concatenate

Load

Name,

branch,

ID,

Date

From

Store [TableName] into (qvd);

I hope this helps you understand