Discussion Board for collaboration on QlikView Scripting.
I was wondering if anyone knows a function to get the hash in the following format:
○ Hashing method: SHA256
○ ID format: 32 bytes id in hex
The result for email: firstname.lastname@example.org, should be:
This is to hash emails to upload into google adwords new Customer Match function.
You can use a macro to calculate the hash using SHA256. Maybe (just did a short web search) using
FreeVBCode code snippet: SHA-256 One Way Encryption: VB and ASP Implementation
Thank you, however I would like to do this in Qlikview or SQL. There is a HASH256() function in Qlikview but it is not giving me the results I need, so I'm guessing I'm missing a step.
AFAIK, Hash256() is not using SHA256, it's using a different hashing algorithm. If you need to exactely use SHA256, I think you need to call some macro or do the transformation outside of QV, before loading the data in.