topic Re: Hashing method to get SHA256 in QlikView

Hashing method to get SHA256

Anonymous — Wed, 18 Nov 2015 21:55:44 GMT

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

Re: Hashing method to get SHA256

swuehl — Wed, 18 Nov 2015 22:21:23 GMT

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

Re: Hashing method to get SHA256

Anonymous — Thu, 19 Nov 2015 08:16:17 GMT

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.

Re: Hashing method to get SHA256

swuehl — Thu, 19 Nov 2015 11:24:06 GMT

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.

Re: Hashing method to get SHA256

madhuparnadhar — Tue, 14 May 2019 13:13:01 GMT

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