Incremetal Load script

[master_student]

Hello everyone,

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

Thank you

[tresesco]

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?

[makrishnaraj]

Hi

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;

[gautik92]

Check this blog

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

[master_student]

I don't have PrimaryKey in my table

how to get $(LastExecTime)?

[gautik92]

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

[master_student]

Thanks

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

[gautik92]

Contact Database Team and tel them to add the Date Field