Separation of the PII data in Report

To separate PII data in the reports, perform the following steps:

1. Configure the reports as per your needs and requirements in Sigma Studio. To configure a report, refer Configuring a Simple Report.

2. Click the report column whose data you need to separate in the Select Columns to Display field, e.g. PHONE_NUMBER.
   
   

   Open

   

    

3. In Column Attributes, click + icon adjacent to Select Masking format lookup field.
   
   

   Open

   

   
   The Data Masking screen appears.
   
   

    

4. Enter a unique name in the Pattern Name field.
   
   

    

5. Provide the sample data in the Sample Data field to try separation with the given sample data.
   
   

    

6. Choose Separation from the Expression type drop – down to perform separation of data.
   
   

   
   By default, space is taken as separation character in the With Char field.
   
   

    

7. Enter a character to be used as data separator in the report in With Char field.

8. Enter the number of character after which the separator needs to be used in report, in the Starting position field.

9. Enter number of times the separator needs to be used in the data, in the Max Times field.

10. You can view the preview of the separated data in the Expected Format field for the applied parameters.
    
    

     

11. Click Save to save the configured separation expression.
    
    

     

12. Choose the configured separation format from the Select Masking Format lookup field, to use it in the report.
    
    

     

13. Click Save to save the configured report with the separation expression.