Skip to main content

Compose Math Expression Masking

The Compose Math Expression masking generates a value by performing a calculation on two or more fields in the row. The components of the math expression can include any numeric column in the table and any of the following operators:

  1. +

  2. -

  3. *

  4. /

The Compose Math Expression masking is suitable where:

  1. When the field to be masked is a numeric and derives its value from other source fields in the same row.

  2. One or more of those source fields will be separately masked.

  3. You want to make the value in the dependent field reflects the new (masked) values in the source fields.

To apply Custom Math Expression, enter the following information:

  1. The Column Name field display the list of all column names based on which masking can be applied. The Custom Math Expression can only be applied over the numeric datatypes such as decimal, numbers, int, etc. Therefore, columns having numeric datatype are shown in the Column Name drop-down.

  2. The Operator drop-down displays the four different operators based on which the calculations are performed between two or more columns to mask the dependent field. The four different operators are:

    1. +

    2. *

    3. /

E.g., with reference to below image, if you want to mask the data in ZIP field then perform calculation between two or more numeric datatype columns and use the outcome to mask the dependent field. Here, we are performing the calculation between emp_cd and telephone columns to mask the ZIP field.

Select the two or more column names in the Column Name drop-down and select an operator based on which the calculations are performed. For Instance, the ZIP for record 1 will be masked with outcome: 11,311, when addition is performed between emp_cd: 100 and telephone: 11,211 i.e., 100 + 11,211 = 11,311.

In the below image, on executing the task, the data in the target database is masked with the outcome when addition is performed between emp_cd and telephone column. For Instance, the ZIP for record 2 was 333 originally. After applying masking option, the values for record 2 changed to 22,424.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.