Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Scrambling data records, not columns

Has anyone scrambled data for specific records? We're a PBM who hold prescription/pharmacy data, and would like to scramble the names of the employees who work here so other employees can't snoop on their coworkers.

3 Replies
mov
Esteemed Contributor III

Scrambling data records, not columns

I doubt you can scramble the records, but you can simply restrict access to the records by using data reduction based on Section Access.

Regards,
Michael

yblake
Contributor II

Scrambling data records, not columns

you may use load dual ( VendorName,VendorId ) as VendorId to set real Vendor names to some vendors, and fake names (use autonumber, rand or fixed string) to others.

Your data model will use Vendor Ids internally, but listbox or charts will display the text from this table.

MVP & Luminary
MVP & Luminary

Scrambling data records, not columns

If the name field is not a Key, and you have some flag that identifies Employees, you could do something like:

if(Employee = 'Y', 'Confidential', Name) as Name

If Name is a key, you could use mapping to change the name for employees only using applyMap(). You would need to check an Employee flag first if there is a chance that an Employee and Customer had the same name.

-Rob

Community Browser