Data Desensitization

1.1 Expected effect

Data desensitization refers to the deformation of data through desensitization rules for certain sensitive information to achieve reliable protection of sensitive private data.

For example, phone numbers and bank names are desensitized as shown in the following figure.

1.2 Implementation idea

Process data in a self-service dataset, using the Replace function for field replacement.

For example, to desensitize phone numbers, the example uses the Demo data "Supplier Information table".

2.1 Add Self-Service dataset

Add the "Desensitization" Self-Service dataset and select the field as shown below.

2.2 Add new column

Add a new column "Phone Desensitization", use the formula REPLACE function for field replacement, enter the formulaREPLACE(phone,3,7,"xxxx"), as shown in the following figure.

2.3 Effect view

The effect of field replacement using the REPLACE function is shown in the following figure.

Example data: replacement characters.xlsx

3.1 Add Self-Service dataset

Add the "Desensitization" Self-Service dataset and select the fields as shown below.

3.2 Add new column

Add a new column "Bank Desensitization", use the formula REPLACE function for field replacement, enter the formulaREPLACE(Bank,LEFT(Bank,FIND("B",Bank)-1),"xx"), click "OK", as shown in the figure below:

Note: The functions and fields in the formula box need to be selected by clicking the selection area on the left, and cannot be entered manually.

Formula Description:

3.3 Effect view

The effect of field replacement using the REPLACE function is shown in the following figure.