Incremental Load

[#1]

Hi all,

I have a excel data from the month of Jan11 to July11

now i want to give incremental load in it by concatenating the upcoming xls eg:Aug11

I never tried incremental load before.

Please anybody help me in it.

thanks in advance

[kaushiknsolanki]

Hi,

    Have a look at the documents available here.

    http://community.qlik.com/search.jspa?resultTypes=document&dateRange=all&peopleEnabled=true&q=increm...

Regards,

Kaushik Solanki

[suniljain]

pls check following script which perfrom insert,update and delte operation in increamental load

Let ThisExecTime = Now( );

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If