Hash Function

[noman212]

Hi Friends,

i made a QVD with incremental load Insert update the records insert in qvd on daily basis, in my database password field update when user changes their password.

The changed in password feild not update in my QVD.

How can i apply hash funtion so that i get updated value.

Regards

Noman khan

[Gysbert_Wassenaar]

See this blog post: http://www.qlikfix.com/2014/03/11/hash-functions-collisions/

[fkeuroglian · Accepted solution]

Hi

you have to create a code using hash function like this:

Hash128(FIEDL1,FIELD2,FIELDn) as %KHash,

then when you load the new data create another field using hash again and put %KHash2

then load and put a where clause

load *

from...

WHERE not exists (%KHash2, %KHash);

only will be load the value that have some change in the hash or are new

good luck

Fernando

[noman212]

Thankyou fkeuroglian for your reply m going to implementing according to yours suggestion. if required i will take your help