topic Re: Hash Function in QlikView

Hash Function

noman212 — Fri, 30 Jan 2015 05:26:23 GMT

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

Re: Hash Function

Gysbert_Wassenaar — Fri, 30 Jan 2015 12:40:25 GMT

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

Re: Hash Function

fkeuroglian — Fri, 30 Jan 2015 17:30:21 GMT

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

Re: Hash Function

noman212 — Sat, 31 Jan 2015 05:20:54 GMT

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