Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
JCJnr
Contributor III
Contributor III

Data Transformation - Hashing a column value

Hi

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?

 

Labels (3)
1 Solution

Accepted Solutions
Heinvandenheuvel
Specialist III
Specialist III

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.

 

Heinvandenheuvel_0-1651844379364.png

Hein.

View solution in original post

1 Reply
Heinvandenheuvel
Specialist III
Specialist III

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.

 

Heinvandenheuvel_0-1651844379364.png

Hein.