Anonymize/Mask the Person's Name from the comment field

[harinder1301]

Hi ,

I would like to mask or anonymize the person's name in comment text field. for eg : Lee is good person should be mask to abc is good person etc.

is there any way to do this in Alteryx?

Thanks

Hsac

[messi007]

@harinder1301,

You can extract the list of the name from the data source

Use https://www.mockaroo.com/ to create a list of name

Then use join by position to get the new names :

Attached the workflow,

Hope this helps!

Regards,

[ddiesel]

Hi @harinder1301!

To build on @messi007's suggestion, you might also look into the functionality of the Find and Replace tool.

[harinder1301]

Thanks, Is there any way to find the names of the persons from nearly 5000 comments? 

[ddiesel]

 @harinder1301 - can you be more specific?

If you send some anonymized data, we can help you with a solution specific to your use case.

[harinder1301]

Thanks for the Quick reply.

I have attached some sample records for your reference.

Regards

[messi007]

@harinder1301,

Similar to @ddiesel workflow  :

Hope this helps

Regards

[harinder1301]

Thanks for the reply. Actually my question is " How can i identify the names from 5000 comment rows?"

Is there any tool in Alteryx to identify the names from the comment?

Appreciate your reply.

[ddiesel]

@harinder1301 Do you have the list of names? What do you want the final output to look like?

[harinder1301]

Hi,

No, We don't have person list. This can be first name/known as/or surname etc. This the feedback provided. Here is the desired final output:

ID	Comments	Final Output
1	Joe is bad person.	xyz is bad person.
2	yes, I like John.	yes, I like xyz.
3	Would not allow Kiara to come.	Would not allow xyz to come.
4	Wouldn't change a thing.	Wouldn't change a thing.
5	Yet, there is nothing much to change.	Yet, there is nothing much to change.
6	Trin is very slow.	xyz is very slow.
7	I like yun.	I like yun.
8	Yes, Peter is not a good.	Yes, xyz is not a good.
9
10
..5000

Thanks for your help!

Regards