Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Hashing method to get SHA256

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

4 Replies
Highlighted
MVP
MVP

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

Highlighted
Contributor III
Contributor III

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.

Highlighted
MVP
MVP

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.

Highlighted
Contributor III
Contributor III

Hi @swuehl & @betul_korkmaz_e,

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