How to update NULL data to specific data using masking algorithm?

  • 0
  • 1
  • Question
  • Updated 3 months ago
Running masking job to mask something but there are some NULL records i would like to update those records also with some values then how can i update those NULLs with specific values ?
Photo of Rajesh


  • 702 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 6,126 Points 5k badge 2x thumb
Hi Rajesh,

You can achieve your need by running an update of null columns with some values as pre-script of the masking job.

Logically masking a null value which (means no signification nor a sensitive data in it) with a null value stay one of good secure ways of masking.


Photo of Hims

Hims, Employee

  • 2,882 Points 2k badge 2x thumb
Hi Rajesh,
An alternate way is to create a secure lookup algorithm with an empty lookup file. That will convert everything to null.