topic Re: Incremetal Load script in QlikView

Incremetal Load script

master_student — Thu, 14 Jul 2016 10:51:50 GMT

Hello everyone,

Who can post a simple incremetal load script (insert only)

Thank you

Re: Incremetal Load script

tresB — Thu, 14 Jul 2016 10:56:54 GMT

The Help could.

Insert Only (No Update or Delete)

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(BeginningThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD;

STORE QV_Table INTO File.QVD;

Does this help?

Re: Incremetal Load script

makrishnaraj — Thu, 14 Jul 2016 11:04:55 GMT

Hope this is helpful

You will have to use the below statement to get rid of duplicate records.

WHERE NOT exists(PrimaryKey);

Table1:

SQL SELECT PrimaryKey, A, B, DateTimeField FROM DataBaseTable

WHERE DateTimeField >= $(LastExecTime);

Concatenate LOAD PrimaryKey, A, B, DateTimeField FROM DestFile.QVD

WHERE NOT exists(PrimaryKey);

STORE Table1 INTO DestFile.QVD;

Re: Incremetal Load script

gautik92 — Thu, 14 Jul 2016 11:06:01 GMT

Check this blog

http://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Re: Incremetal Load script

master_student — Thu, 14 Jul 2016 12:33:49 GMT

I don't have PrimaryKey in my table

how to get $(LastExecTime)?

Re: Incremetal Load script

gautik92 — Thu, 14 Jul 2016 12:38:11 GMT

I faced the same issue ..we cant do incremental load without Date and Primary ID We shud have atleast one

if primary ID is not there try with Date.

If you want to do oly insert WHERE NOT exists(PrimaryKey) not needed

remove that from script and try t

Re: Incremetal Load script

master_student — Thu, 14 Jul 2016 12:46:55 GMT

Thanks

How to get the last updated time $(LastExecTime)?

Re: Incremetal Load script

gautik92 — Fri, 15 Jul 2016 04:37:49 GMT

Contact Database Team and tel them to add the Date Field