Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
See this blog post: http://www.qlikfix.com/2014/03/11/hash-functions-collisions/
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
Thankyou fkeuroglian for your reply m going to implementing according to yours suggestion. if required i will take your help