Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

Name Standardization

Highlighted
12 - Quasar
12 - Quasar

I was curious if anyone knows of or has created a dataset of names/nicknames? I probably will end up creating one, but I wanted to take the path of least resistance and see if anyone knows about anything available out there.

 

Example I want to take all Bob, Rob, Robbies and make them Robert. Something like that.

Highlighted
Alteryx
Alteryx

A nice place to start will be the Fuzzymatch nickname set.

 

C:\Program Files\Alteryx\bin\RuntimeData\FuzzyMatch\Nicknames\Common Nicknames.yxdb

 

Note: You can always add sets to this directory in order to use in the Fuzzy Match Tool as an abbreviation Table

 

Kane

Highlighted
12 - Quasar
12 - Quasar

Thank you @KaneG! We started using this set, but were looking for something a little more robust, or perhaps set up for joining rather than matching. It has however been our starting point as you suggested.

Highlighted
12 - Quasar

Here is a resource I found with nicknames and their corresponding long names. https://nameberry.com/userlist/view/83873

 

Hope this helps!

Labels