topic Re: incremental load pls explain me step by step pls.............................. in QlikView

incremental load pls explain me step by step pls..............................

Sat, 08 Feb 2014 15:10:29 GMT

incremental load pls explain me step by step pls..............................urgently.........................

Anonymous — Sat, 08 Feb 2014 15:14:48 GMT

Incremental load – it loads only the new or changed records from Database.

It can dramatically reduce the time needed to reload a qlikview application.

Basic incremental load process

We have various scenarios for incremental load:

Basic Process:

QV_ILoad:

SQL SELECT PrimaryKey,X,Y FROM DATABASETABLE

WHERE ModificationTime>=#$(LastExecTime)#;

Concatenate

LOAD PrimaryKey,X,YFROM File.QVD;

maxgro — Sat, 08 Feb 2014 15:33:21 GMT

I found two old docs, hope the help you

Sun, 09 Feb 2014 06:56:11 GMT

hi Manoj,

load table into qv make qvd and comment entire script.

load qvd file into qv. using let statement save last rec data.

load data base table into qv and write "where data >= $(variblename) .be four load write NoCancat statement.

load table into qv and write "where not exists(...ID)"; be four load write Cancat statement

write store tablename into c:.............\tablenale.qvd(qvd)

Anonymous — Sun, 09 Feb 2014 09:53:58 GMT

Manoj

There are quite few excellent blog posts on Incremental Loads. Here is link to one of them.

Best Regards

Thu, 10 Dec 2015 05:25:48 GMT

Can you please help me in "Incremental Reloads (Insert/Update/Delete) with deletion flag available"

Can you give some example.

Thanks in Advance.