Scrambling Data

    When creating demo applications, there is often the need to scramble the data so that sensitive information is not available to the users.  The data that needs to be scrambled may include data such as companies, names, addresses, phone numbers, email addresses and/or sales figures.  QlikView provides scrambling functionality where the user can select the field(s) to scramble.  This is convenient if you do not care what the scrambled data looks like.  If you want the data to look realistic then you can consider using mapping and modifiers to scramble the data.  This process takes a little more time but in the end the scrambled data looks realistic.  In this technical brief, an approach to handle scrambling the data will be reviewed.

     

    I have also written a blog on this topic.  Check it out.

     

    Have fun scrambling!

     

    Jennell