The Name Synch masking segregate the name in the target field with a name from another field in the same row, automatically adjusting the format as necessary, if specified.
The data in the selected Source Column is used for replacing the data in the target column. This specialized masking is suitable for de-normalized tables in which the same value (in this case a name) appears two or more times in a single row.
*Note: If a desired masking format is not available in the source column, it masks the destination column with all the other masking formats selected in Create Format panel. If no other masking format is selected/present, it masks the destination with NULL value.
To apply Name Synch, enter the following information:
The Source Column drop-down display the list of all columns whose datatype falls in category of string and can be used for name synchronization. Using the Create Format options, you can generate the format of the data.
The Create Format section of the Name Synch panel displays various buttons based on which a segregated name can be generated from the source column. There are 11 buttons:
First Name: Click this button to include the first name of the person. On clicking the First Name button, ‘F’ is entered in the Generated Format textbox.
Middle Name: Click this button to include the middle name of the person. On clicking the Middle Name button, ‘M’ is entered in the Generated Format textbox.
Last Name: Click this button to include the last name of the person. On clicking the Last Name button, ‘L’ is entered in the Generated Format textbox.
Comma: Click this button to enter the ‘,’ (comma) to separate two characters or words. This option is useful when you are specifying the Last Name followed by First Name. On clicking the button, ‘,’ (comma) is added in the Generated Format textbox.
E.g., Conners, Lester. In this example, the Conners being the last name is separated from the first name by comma.
Period: Click this button to enter the ‘.’ (period) while masking the values. This option is useful when you want to abbreviate words such Senior as Sr., Junior as Jr., etc. On clicking the button, ‘.’ (period) is added in the Generated Format textbox.
Space: Click this button to generate a space between two characters. On clicking this button, a space is added between selected options.
E.g., In the above image, a space is added between First Name, Last Name and Middle Name.
First Initial: Click this button to include the first name initial. The range can vary from A-Z, if upper case is chosen in the Case Format else the range can be in between a-z in lowercase. When entering the First Initial, the ‘FI’ is entered in the Generated Format textbox.
Middle Initial: Click this button to include the middle name initial. The range can vary from A-Z, if upper case is chosen in the Case Format else the range can be between a-z in lower case. When entering the Middle Initial, the ‘MI’ is entered in the Generated Format textbox.
Prefix: Click this button to include the prefix while masking. A prefix can be Mr, Mrs, etc. When entering Prefix, the ‘P’ is added in the Generated Format textbox.
Suffix: Click this button to include the suffix when masking. A suffix can be Jr (junior), Sr (senior), I, II, etc. When entering a Suffix, the ‘S’ is added in the Generated Format textbox.
Nick Name: Click this button to generate an informal name that is used instead of real name. On clicking, the ‘N’ is added in the Generated Format textbox.
*Note: If you want to segregate the Nick Name, then data for the Nick Name must be in braces “()” in the Source field.
The Generated Format panel displays the regex generated by you for masking a value. To clear the value in the textbox, click the Reset button.
There are three Case Formats based on which the masked value is generated.
Upper Case - If you select the Upper-Case option, it generates the value where every letter of the word is capitalized.
Lower Case - If you select the Lower-Case option, it generates a random value where every letter of the word in lowercase.
Title Case - If you select the Title Case option, the data in the field capitalizes the first letter of each word. By default, this option is selected.
E.g., with reference to below image, if you want to segregate the data from Full_Name column to Emp_Fname and Emp_Lname column then use the Name Synch masking option. This option retains the format of the data.
Here, we’ve generated a format ‘P. F N’, which is applied on Emp_Fname column. This format will segregate the First Name and NickName in Emp_Fname. Similarly, another generated Format i.e., ‘M L’ is applied on Emp_LName column which segregate Middle Name and Last Name in this column.
On executing the task, the Emp_Fname column is masked with First Name and Nick Name which is preceded by Prefix and a Period. In this same manner, the Emp_Lname is masked using Middle and Last Name.
For instance, in the below image the data in Emp_Fname and Emp_Lname is segregated using the values present in the Full_Name column.