How to rename rows based on 'likeness'?

I’ve used Tableau Prep Builder before, and it had an option that would allow it to algorithmically “fix” some of my data. I could also pretty easily sort this through a UI and "select’ which members belong to each grouping.

I have a list of names that have some minor misspellings, but should be grouped together. Here’s some examples.

Anxsia
Anxsia
Anyisa
Anysia
Anysia

Britney
Brittany
Brittany
Brittany C.
Brittany c.
Brittney
Brittney C.

Chrisitian
Christen
Christian
Christian
Christin
Christin
Christin H
Christin/Brianna
Christin/Ron

Hi @sroberts -

Maybe the Similarity Search node can help here? Take a look at these example workflows:

6 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.