topic md5 in QlikView

md5

Teppo_Ojala — Fri, 24 May 2013 07:08:19 GMT

Hi,

I already read couple of discussions about this topic, but I couldn't find an answer.

I don't know much about md5, but I faced that in my project. I will read some transaction data from csv files and I need to md5 hash one id-field there. Does anyone know the best practise how to do this.

I will add a very simple qvw here. This app reads one column in as inline table. There is only one value "helloworld". Is there a way to hash this value when reading the data in? I can use macro's or what ever needed

Thanks!

Re: md5

fdelacal — Fri, 24 May 2013 07:21:10 GMT

i think you can not do in script.

but yes in layout.

Go to Settings > Document Properties > Scrambling

From the help:

#Document Properties: Scrambling

This page is only available when working with a QlikView document in ADMIN mode. It provides the possibility to scramble the data in one or more fields.

Fields	This is a list of all fields in the document. Select one or more fields for scrambling.
Scramble	Press this button to perform a random scrambling of the contents of selected field(s). Numbers are scrambled to numbers and text to text (spaces are kept). Once scrambled, the data cannot be recreated in its original form by QlikTech or anyone else. If you re-execute the script, however, the scrambling will be lost.

hope that helps you.

Re: md5

Teppo_Ojala — Fri, 24 May 2013 07:29:02 GMT

One addition..

Scrambling and hash-functions are not an option.

I don't even know if my case is possible or not. But, I will get data from 2 different sources. From source one I will get the id's as they are (for example 1234567890), from another the id's has been crypted by md5-function (1234567890 -> ws3rfwD#d4#)

In the project I should combine the two datasources and for example count the distinct amount of id's.

So (if I understood correctly), if I could do the md5 encrypting in QlikView using the same "keyword" (?) as they have used in another source, I could combine these and do analytics easily.

Sorry about my bad undwerstanding of md5. Totally new thing for me..

Re: md5

Teppo_Ojala — Thu, 30 May 2013 19:57:32 GMT

Hi,

I will answer to my own question. My colleague solved this for me.

Attached a file which uses MD5-macro as I needed.

Re: md5

pablolabbe — Tue, 23 Sep 2014 17:51:54 GMT

Great Job.