Hashing method to get SHA256

[Anonymous]

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

[swuehl]

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

[Anonymous]

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.

[swuehl]

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.

[madhuparnadhar]

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