Skip to main content

Email Policy Masking

The Email Policy masking generates/masks an email address by combining values from two other fields in the same row along with a domain and extension that you specify. The Email Policy option is best used in situations where business rules require:

  1. A specific, invariable format for email addresses.

  2. Synchronization between elements of the email address and information contained in other fields (typically the first and last name fields).

This masking can be applied on columns having string datatypes. To apply Email Policy masking, enter the following details:

  1. In the first section, select a column from the First Column Name drop-down. This field display the list of all the column names available for the selected table. This section also displays the maximum length of the selected column.

    You can mention the character position counter in Start Position drop-down. This value is the one from where the characters will be picked. The Length drop-down allow you to specify the number of characters to be used for masking.

  2. The Connector field allows you to enter any special character, numeric value or an alphabet which will concatenate data picked from First Column Name and Second Column Name.

  3. In the second section, select a column from the Second Column Name drop-down. This field display the list of all the column names available for the selected table. This section also displays the maximum length of the selected column.

    You can mention the character position counter in Start Position textbox. This value is the one from where the characters will be picked. The Length textbox allow you to specify the number of characters to be used for masking.

  4. In the bottom section, mention the fictious value for the Domain Name and Extension to make data look more realistic.

E.g., with reference to below image, if you want to mask the email_id address in the target database with some random data from the table itself then you can apply Email Policy Masking.

Here, we are using data from emp_cd, with maximum length of five characters, and hire_date, with maximum length of 10 characters. To concatenate values from both the columns, “_” (underscore) is used a connector. A random value for Domain Name= dg and Extension=.com” is used.

On executing the task, the data in email_id column is masked with the values you’ve defined. For Instance, in the below image, the email_id for record one is masked with value 100_2020-12-22@dg.com. Originally, the data in the first row was benjamin.christopher@google.com.

JavaScript errors detected

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

If this problem persists, please contact our support.