What is the best algorithm to mask a column which have "Last Name, First Name (Location)"?

  • 1
  • 1
  • Question
  • Updated 4 weeks ago
  • Answered
What is the best algorithm can be used to mask a column which have "Last Name, First Name (Location)"?
Eg:
If a column named as DISPLAYNAME with below fields are there and want to know the best way to mask it.
Clifford, Patrick (US - Retired)
Dagnelie, Paul (Boston)
Rupp, Michael (Dallas)
Seo, Yeonok (Boston)
Duff, William S. (Dallas)

FYI,
I have a algorithm with LASTNAME_COMMA_FIRSTNAME_SL(Secure Lookup). 
Now I want to know if this algorithm can be used for masking name alone and then apply Secure Shuffle to Location which means applying two algorithms on the same column. If so how it is possible.
Or any other approach to mask this?

Kind Regards,
Rajesh
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb

Posted 4 weeks ago

  • 1
  • 1
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 646 Points 500 badge 2x thumb
Hi Rajesh,

In my view the easiest way to mask this is to create a Secured Lookup which has values for LASTNAME,FIRSTNAME (LOCATION). Sample values like :

Dadi,Rajesh (Boston)
Schumacher,Michael (Dallas)

Please let me know if there are concerns with this solution.


Regards,
Mayank
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 5,846 Points 5k badge 2x thumb


Hi Rajesh,

In my view Mayank is right, you will have only one pass to get all columns masked, but this solution implies generation a secure lookup file.

You solution will need 3 passes masking fist_last_names (1), secure shuffle city (2), update first_last_names_cities column (3).

Regards,

Mouhssine

Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb
Thanks a lot Mayank and Mouhssine. I did the same you suggested and worked.