Incremental Load

[Anonymous]

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

Thanks in Advance.....

[its_anandrjs · Accepted solution]

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

One of them from example

[Anonymous]

Thank u anand....

[rido1421]

Hi Venkat

What would you like to Achieve with your incremental load.

what data source will you be extracting from?

[

[Anonymous]

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...

[rido1421]

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