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.
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.