Test Data Manager

Expand all | Collapse all

masking function to allow columns values as duplicate

Jump to Best Answer
  • 1.  masking function to allow columns values as duplicate

    Posted 11-25-2019 11:35 PM
    I have an example where columns to be masked in a table as duplicate. in the below example James Smith record has two entries, the requirement is to mask first_Name and Last_Name

    First_Name    Last_Name     Department_name   Category

    James             Smith                   HR                       Manager
    James             Smith                   IT                         Manager
    Nate                Carlos                  IT                         Lead

    after masking, the output should look like this

    First_Name    Last_Name     Department_name   Category

    Richard           Williams               HR                       Manager
    Richard           Williams               IT                         Manager
    Greg                Chapel                 IT                         Lead

    any suggestion, on how to build custom defined function. or Any inbuilt in function that take care of it


  • 2.  RE: masking function to allow columns values as duplicate
    Best Answer

    Posted 11-26-2019 04:28 AM
    Hi,

        The HASHLOV function should mask the data in the way that you are looking for, this is a description of HASHLOV:

        The HASHLOV function consistently converts an existing value to an integer value in a given range. For example, if you mask a person LAST_NAME, and use the seed data category LASTNAME (which has 2000 entries), the existing LAST_NAME value is assigned a number from 1 through 2000. This value is used to look up the corresponding value in the seed list. For example, the LAST_NAME Jones is always masked to value Burton. 

    ------------------------------
    Regards

    Keith Puzey
    Client Services Consultant | Enterprise Software Division
    Broadcom
    ------------------------------