Data Transformation - Hashing a column value

JCJnr — Fri, 06 May 2022 08:42:50 GMT

Currently the option exist to transform a column value by using the "HASH-SHA256" function.

I need to understand what level of Hashing is this? SHA1, SHA2 or SHA3?

If it is not SHA3, when could we expect something like this to be available.?

If not available at all, what are my options?

Re: Data Transformation - Hashing a column value

Heinvandenheuvel — Fri, 06 May 2022 13:40:28 GMT

SHA256 is member of the SHA-2 family. See: https://en.wikipedia.org/wiki/SHA-2

IMHO Replicate need not and should not add other hash functions as it wil never be good enough for everyone.

The Replicate documentation does not suggest or claim its main objective is a high security function judging by the wording. "The function is especially useful for masking sensitive information. In the expression below, for example, the Hash function has been used to obfuscate employees' email addresses."

If this function is not deemed adequate, then you may want to consider integrating your own vetted code with Replicate through a User Defined Function transformation. Those are a bit tricky to configure for a first time, so you may want to engage Professional Services for that.

Hein.

topic Data Transformation - Hashing a column value in Qlik Replicate

Data Transformation - Hashing a column value

Re: Data Transformation - Hashing a column value