The alpha_values.csv file contains the allowed alphabetic
values: all letters in the A to Z range (minus S, L, O, I, B, Z). The
alphanum_values.csv file contains the allowed alphanumeric values:
the values from alpha_values.csv and digits.

1. Double-click tPatternMasking to display its
   Basic settings view in the
   Component tab.
   

2. If required, click Sync columns to retrieve the schema
   defined in the input component.
3. Click the Edit schema
   button to open the schema dialog box.

   tPatternMasking adds a read-only
   column to the output schema.

   

   The ORIGINAL_MARK column labels output records:

   • Original records are labeled with the true label.
   • Substitute records are labeled with the false
     label.
4. In the Modifications table, click the
   [+] button to add ten rows for configuring the data
   masking operations.
   The first nine rows define the masking operation for each of the first nine
   characters in the input values. The last row define the masking operation for
   the last two characters in the input values.
   The dash is used as a separator in the input values. You do not need to
   configure masking operations for separators because the masked output has the
   same separators as the input values.
5. Configure the masking operations for the first, fourth and seventh characters
   that appear in the input:
   1. Click the Column to mask field of the first row
      and select the column that contains the data to be masked.
      In this example, select MBI.
   2. From the Field type field, select
      Interval as the field type the data belongs
      to and enter the range of authorized numeric values in the
      Values field.
      In this example, the purpose is to mask the first character with a
      digit in the 1 to 9 range ("1,9"). The fourth and
      seventh characters will be masked with a digit in the 0 to 9 range
      ("0,9").
   3. Apply the same configuration to the fourth and seventh rows of the
      Modifications table.
6. Configure the masking operations for the second, fifth, eighth and ninth
   characters that appear in the input:
   1. Click the Column to mask field of the second row
      and select the column that contains the data to be masked.
   2. From the Field type field, select
      Enumeration from file.
   3. Click the Values field and press Ctrl
      + Space to select the variable for the file that
      contains the authorized values.
      In this example, select the variable for the file that contains the
      authorized alphabetic values.
   4. Apply the same configuration to the fifth, eighth and ninth row of the
      Modifications table.
7. Configure the masking operations for the third and sixth characters that appear
   in the input:
   1. Click the Column to mask field of the third row
      and select the column that contains the data to be masked.
   2. From the Field type field, select
      Enumeration from file.
   3. Click the Values field and press Ctrl
      + Space to select the variable for the file that
      contains the authorized values.
      In this example, select the variable for the file that contains the
      authorized alphanumeric values.
   4. Apply the same configuration to the sixth row of the
      Modifications table.
8. Configure the masking operations for the last two characters that appear in the
   input:
   1. Click the Column to mask field of the last row
      and select the column that contains the data to be masked.
   2. From the Field type field, select
      Interval as the field type the data belongs
      to and enter "0,99" for the range of authorized
      numeric values in the Values field.
      In this example, the purpose is to mask the characters with two
      digits in the 0 to 9 range.
      To mask each of the two characters separately, you can add a row to
      the Modifications table, define two masking
      operations and enter "0,9" for the range of
      authorized numeric values.