This depends if the "lastname" gets masked in the same table during same transaction or not.
If you mask "lastname" then you can use a postscript for that table : update TABLE set keyword = lastname where name = null ;
If you don't mask lastname you can use a prescript with similar logic.
Another option is to create a custom extensible SDK framework doing exactly what you want in one transaction.
You would create a framework with 3 or more columns : name, lastname, keyword .. and configure the logic as required.
The logic to mask the name / lastname can use CHAINING > e.g. your framework can call the existing dlpx-core:FirstName / dlpx-core:LastName algorithms and based on the results you decide in your framework how to update your columns.
The Delphix masking extensible framework is available for free on Delphix download.
Details about SDK you find here:
https://maskingdocs.delphix.com/Authoring_Extensible_Plugins/IntroductionIf you wish Delphix to create such a customisation for you please get in touch with your Customer Success Representative.
------------------------------
Tino Pironti
Masking SME
Technical Manager
Delphix
------------------------------
Original Message:
Sent: 05-24-2022 01:47:13 PM
From: Raj Kumar
Subject: Delphix custom Algorithms
Hi All,
We got below masking requirement and we already checked existing algorithms in Delphix engine but that does not work for this requirement.
If name field is not null, then do not mask keyword fields (it will already equal name).
If name field is null, then keyword should be set to be equal to lastname (which is masked).
Please note : Name is non senstive filed and keyword and lastname are sensitive fields which we are using masking algorithms .
Kindly help me in this masking Process
Thanks
Raj
------------------------------
Raj Kumar
Data Engineer
Liberty Mutual Insurance Company
------------------------------