Unique anonymize customer names in two different table with Relationship

Hi klikk680 ,

My sample data is this.

Table1

NameSales

Table2

NameDate

The way to keep anonymous names in the original relationship between the two tables is to ensure that they are not the same.

You could create a calculated column both in Table1 and Table2.

Anonymised = "Name " & RANKX('Table1',[Name],,ASC,Dense)

Anonymised = "Name " & RANKX('Table2',[Name],,ASC,Dense)

Or you could use spaces to distinguish.

Name     Anonymised Name
"Bob"    "Name xxxxxxx"
"James"  "Nmae xxxxxxx "
"Jimmy"  "Name xxxxxxx   "

Anonymised 2 = "Name XXXXXXX" & REPT(" ", RANKX('Table1',[Name],,ASC,Dense))

Anonymised2 = "Name XXXXXXX" & REPT(" ", RANKX('Table2',[Name],,ASC,Dense))

Even if the Name column is not used as the relationship, the anonymous column can still maintain the original relationship.

You can check more details from here.

Reference:How to anonymize/mask part of Data

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

You can