Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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: example@gmail.com, should be:
264e53d93759bde067fd01ef2698f98d1253c730d12f021116f02eebcfa9ace6
This is to hash emails to upload into google adwords new Customer Match function.
Thanks,
Betul
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.
Hi @swuehl & @Anonymous,
I am stuck with a similar problem where I need to hash data in Qlik Sense using SHA - 256. Could you guys please help in figuring out how this can be achieved in Qlik Sense ?
Thanks and Regards,
Madhuparna Dhar