Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

Incremental Load with AutoNumberHash()?

Hi Community,


Here is what i am trying to do, I have table from SQL server which a primary key but no Update/Modification DateTime. So I am trying to create a AutoNumberHash128() Key for every record in the Initial load. If a Record is Updated Hashkey will be different and PrimaryKey will be same from the initial load. How do we load only Upadted records into QVD.



Select * from NewQVD N

Where Not Exists(Select  HashKey from IntialLoad  I where I.PrimaryKey=N.Primarykey)


For New records primary key will be not present in Intial Load.

If some one implemented Incremental Load without Update/Modification Time using Hash key, advice me in right direction.

Thanks & Regards

Afroz Shaik.