Test Data Manager

Expand all | Collapse all

Conditional based masking for certain records in a table

Jump to Best Answer
  • 1.  Conditional based masking for certain records in a table

    Posted 11-25-2019 11:39 PM

    Hi,

    I have a simple scenario where I want to mask Texas state based records first and last name and leave other state records as is.

    can you please advise an approach to create a custom function.

    Thanks and Regards,
    Koti


  • 2.  RE: Conditional based masking for certain records in a table
    Best Answer

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

           If you make a copy of an existing masking function you can add a where clause to only mask values that match the where clause. In my example the where clause is querying a different table for all records that match the query.




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

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