INCREMENTAL LOAD

[d_koti24]

I WANT KNOW ABOUT THE INCREMENTAL LOAD

[arulsettu]

hi

check this

Incremental Load in QlikView – Part1 | Learn QlikView

[Gysbert_Wassenaar]

See this discussion: Dynamic Update and Incremental Loading

[MayilVahanan]

Hi

Please refer this link

http://community.qlik.com/docs/DOC-4597

Incremental Load.docx

[its_anandrjs]

You can read this best document also for the Incremental load

[ramasaisaksoft]

Hi Kote,

         incremental load is nothing but you load the data into u r .QVW(Qlikview Window) file by .QVD files(Qlik view Document ) just like u load .CSV files and Database files(Tables)

        How to create a test.QVD file is

          load * from emp_table;

          select * from emp_table;

          Store emp_table into D:\QVD_files \test.qvd;//it is a command for creating the QVD file.

          So QVD file is stored in D  drive QVD_files folder and the name as test.QVD but u can't open these files directly ,these files u can use in QVW files.

       How to Use tset.QVD file in incremental. QVW file

       load *  from D:\QVD_files \test.qvd (qvd);

this entire process is called Incremental Load.

if u need any other details please contact me on ramasaiqvw@gmail.com at any time.(i will speak Telugu also).

[d_koti24]

K....thank u boss

[#8]

Hey Please help ….. I am getting all the emails on my working email address ..do you know where can I de-Activate this ?

[d_koti24]

i dont knw boss

[its_anandrjs · Accepted solution]

Hi,

Let me clear about the Incremental load There are 3 types of the Incremental load

Insert

Update

Delete

But depends on the scenarios how you use it

Step One:- Load Initial table

TableName:

Load * from Location;

Store TableName into TableName.qvd(qvd);

Step Two:- Insert based on the Primary keys

MaxIDTable:

LOAD Max([Indentity Number]) as MaxIncrID

FROM CUSTOMERS.xls

LET vMaxIncrID = peek('MaxIncrID',0,'MaxIDTable');

Step Three:-

TableName:

LOAD *

From Raw Source Location

WHERE [Indentity Number] >= $(vMaxIncrID);

Concatenate

LOAD

*

FROM

TableName.qvd (qvd);

STORE TableName into TableName.qvd(qvd);

DROP Table MaxIDTable;