Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More

Masking data in QlikView

etl_tools
Contributor

Masking data in QlikView

Typical situation demo is tomorrow and we need to hide some sensitive information from the users like people names and addresses

Here we have "Mothly pancake cunsumtion by word famos tennis players" (or winning by eating )  QlikView dashboard

Obviously it is a TOP SECRET information. No one should know the magic number of pancakes required to eat to win the championship.

ETL_QlikViewConnector_2.png

This can be easily done by using ETL Tools QlikView connector. First field holds the ranking, first name, last name and country and it is space delimited.

We split the data first using Splitter object and space as delimiter, than we join first name, last name back using joiner object. Country code has some brackets so we remove them using delete characters function.

ETL_QlikViewConnector_3.pngNext step to mask/encode the data. We do that by using Lower case + Replace characters + Proper case functions.

ETL_QlikViewConnector_5.pngThe key here is Replace characters function. every character from the top part is replaced with the character from the bottom Q is replaced with A so we get completely unreadable data

ETL_QlikViewConnector_4.png

Result of transformation

Result.png

Let load the data into QlikView:

QlikView.png

And here is our data:

QlikView2.png

More Information about QLikView connector:

ETL-Tools QlikView Connector is an ideal tool for customers who are working with complex and bad quality data. Cleaning and conforming the data can be tedious task. ETL-Tools QlikView Connector gives the users ability to transform and validate the data while loading it QlikView. It has more than 300 functions and can load the data from Flat files, Excel, MS Access, DBF, FoxPro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, POP3 + SSL, File System, XML and even QVX files.

ETL-Tools QlikView Connector can transform and validate Strings, Numbers, Dates, Postcodes, phone numbers, Driving licences and much more. All this can be achieved without writing a single line of code.

Comments
MVP & Luminary
MVP & Luminary

But this is reverse readable very easy and it doesn't hide numbers (like account ID).

It's much better and more secure to use the QlikView integrated feature Scrambling in the document properties.

0 Likes
etl_tools
Contributor

Ralph it is debatable which way is better.

Our software has more than 300 transformation and validations functions.

Plus number of them is growing every day and we did a lot of opimizations so it is much faster now

People post their suggestions, we implement them.

Have a look at our support forum you will see what I mean

http://www.etl-tools.com/etl-forum.html

Another way of doing that is to use Checksum function

CheckSum.png

I believe QlikView support only md5 we support 16 checksum types

http://www.dbsoftlab.com/etl-tools/qlikview-connector/overview.html

MIke

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2012-04-29 03:42 PM
Updated by: