topic Re: Increment load in QlikView

Increment load

Sat, 24 May 2014 12:00:26 GMT

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

fkeuroglian — Sat, 24 May 2014 13:36:58 GMT

Hi, see this links

hope this helps

Good luck

Fernando

whiteline — Sat, 24 May 2014 14:22:51 GMT

Hi.

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

Anonymous — Sat, 24 May 2014 15:01:42 GMT

Can you brief more on this.

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

Thanks & Regards,

Kiran Kokade

Joseph_Musekura — Sat, 24 May 2014 15:55:35 GMT

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 — Sun, 25 May 2014 06:14:09 GMT

Hi,

Attached document might give you a better idea.

Regards

ASHFAQ