topic Readable data scramble in QlikView

Readable data scramble

dpietersz — Thu, 23 Apr 2009 20:19:12 GMT

Hi,

I made a QV app and I want to scramble the data so my sales managers can use it for demo purpose.

The standard scramble function makes the fields unreadable.

Is there another technique I could use to scramble data but keep it readable?

Readable data scramble

Anonymous — Thu, 23 Apr 2009 20:28:48 GMT

Not really, as far as I know.

One thing you can do is scramble only the sensitive fields.. Customer names etc and keep the numeric values intact to show proper sales for an untraceable Customer. Just make sure that one country doesn't have one single customer though as that would make identification fairly simple 🙂

Readable data scramble

dpietersz — Thu, 23 Apr 2009 21:17:27 GMT

That's what I already did but you know Sales people . I had to scramble the Customers and also de contactpersons. But for demo purposes they want more readable name's.

Maybe I could do something in the Load script to mix-up names or part of names?

Readable data scramble

Oleg_Troyansky — Thu, 23 Apr 2009 22:19:34 GMT

Create a mapping table of your real customers, mapping them to the made-up names. Then, use ApplyMap() to map your customers and/or Contact Persons.

Use a default value, so that if you have a customer that's not mapped, his name would be replaced with a default like "Elvis Presley" or something like that.

Oleg

Readable data scramble

dpietersz — Thu, 23 Apr 2009 22:28:44 GMT

Thx Oleg,

That sounds like a good solution!

Readable data scramble

rwunderlich — Fri, 24 Apr 2009 00:01:25 GMT

An easy way to generate some random names -- or other test data -- is http://www.generatedata.com

-Rob

Readable data scramble

dpietersz — Fri, 24 Apr 2009 14:20:31 GMT

Hi Rob,

Excellent tip!!!

This is the perfect solution together with the Applymap suggestion of Oleg!