topic Incremental Load in QlikView

Incremental Load

Wed, 07 Sep 2011 09:59:59 GMT

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 — Wed, 07 Sep 2011 10:14:48 GMT

Hi,

Have a look at the documents available here.

Regards,

Kaushik Solanki

suniljain — Thu, 08 Sep 2011 06:43:31 GMT

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

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