topic Scrambling data records, not columns in QlikView

Scrambling data records, not columns

Fri, 01 May 2009 04:08:05 GMT

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.

Scrambling data records, not columns

Anonymous — Fri, 01 May 2009 04:22:10 GMT

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

Scrambling data records, not columns

yblake — Fri, 01 May 2009 04:25:13 GMT

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.

Scrambling data records, not columns

rwunderlich — Fri, 01 May 2009 07:06:41 GMT

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