Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
afroz_shaik
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.

(

In SQL

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.