topic Re: Incrementalload in QlikView

Incrementalload

Fri, 23 May 2014 17:02:21 GMT

Hi can any body provide me executable incremental load for updation and deletion is there in Db

Re: Incrementalload

its_anandrjs — Fri, 23 May 2014 18:05:21 GMT

What do you mean by Executable incremental load script, you can find this script in the resource location also.

Re: Incrementalload

Fri, 23 May 2014 18:09:18 GMT

I need simple script to understand functionality for updation and deletion is there.

Regards

Re: Incrementalload

Ricardo_Gerhard — Fri, 23 May 2014 18:46:06 GMT

If you want to reload only pre-defined values, try to use where condition in locad script.

Another option is use a column flag like "wasmodified" or "datamodified" to incremental load.

Re: Incrementalload

maxgro — Fri, 23 May 2014 18:50:29 GMT

copied from Qlikview online help

(search incremental load)

Case 4: Insert, Update and Delete

The most difficult case to handle is when records are actually deleted from the source database between script executions. The following conditions apply:

The data source can be any database.
QlikView loads records inserted into the database or updated in the database after the last script execution.
QlikView removes records deleted from the database after the last script execution.
A field ModificationDate (or similar) is required for QlikView to recognize which records are new.
A primary key field is required for QlikView to sort out updated records from the QVD file.
This solution will force the reading of the QVD file to standard mode (rather than optimized), which is still considerably faster than loading the entire database.

Script Example:

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

Re: Incrementalload

Sat, 24 May 2014 09:24:12 GMT

your answer is good.i need code for that.

Regards