Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Teppo_Ojala
Employee
Employee

md5

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!

4 Replies
fdelacal
Specialist
Specialist

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.

Teppo_Ojala
Employee
Employee
Author

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..

Teppo_Ojala
Employee
Employee
Author

Hi,

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

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

pablolabbe
Luminary Alumni
Luminary Alumni

Great Job.