Increment load

[#1]

Which function will use when devlop an insert and update incremental load process with QVD files

[fkeuroglian]

Hi, see this links

hope this helps

Good luck

Fernando

Three Types of Qlikview Incremental Loads | resultdata

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

[whiteline]

Hi.

There is no such function. You have to recreate QVD files.

[Anonymous]

Can you brief more on this.

What you want to do just incremental update or SCD loading.

Thanks & Regards,

Kiran Kokade

[Joseph_Musekura]

Hi,

You could to use conditional WHERE (to check last changes) and Not Exists () to manage duplication.

Check this example used to Insert & update for  incremental load process

Table1:

Load * ;

SQL SELECT PrimaryKey,  X,  Y

FROM DataBase_TABLE

// this depend on how you check the changes made after the last reload

WHERE ModificationTime >= #$(LastExecTime)# ;

Concatenate

LOAD PrimaryKey,  X,  Y

FROM savedFile.QVD

// manage  duplication

WHERE NOT Exists (PrimaryKey);

STORE Table1 INTO savedFile.QVD;

Regards,

[ashfaq_haseeb]

Hi,

Attached document might give you a better idea.

Regards

ASHFAQ