Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

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
Partner - Creator II
Partner - Creator II

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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