Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi how to use autonumberhash128 and 256 functions in script
Hi, Hari.
This same question was asked today by Manojqlik. Do you work together ?
what is autonumber hash function ? autonumberhash 128 and autonumber hash 256?
Cheers,
Neil
Hi hari,
just look it up in the manual. It's quite easy.
Both of these functions can be used to hide, e.g. personell_numbers in a qlikView_application and replace them by arbitrary values. You just need to make sure that you don't have to process them any further and/or combine them with any other data.
Best regards,
DataNibbler
No neil,
I got the doubt
usually in qlikview online help you can find the answer to this type of questions
example, copied from online help, in bold how to use in the script
autonumberhash128(expression {, expression})
Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.
Example:
autonumberhash128 ( Region, Year, Month )
autonumberhash256(expression {, expression})
Calculates a 256-bit hash of the combined input expression values and returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key. This function is only available as a script function.
Example:
Autonumberhash256 ( Region, Year, Month )