Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
betul_korkmaz_e
New Contributor

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

3 Replies
MVP
MVP

Re: Hashing method to get SHA256

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

betul_korkmaz_e
New Contributor

Re: Hashing method to get SHA256

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.

MVP
MVP

Re: Hashing method to get SHA256

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.

Community Browser