Hi,
I am trying to create a fuzzy match logic but completely clueless about it and the results are very bad.
I have a master table with 48 'Business Titles' and corresponding 'Cleansed Roles' against it. Suppose, I get 4 new Business Titles which are similar to any of the 48 business titles but are not an exact match so I cannot do a lookup, but I want fuzzy match to provide me with the closest match. Below is the master list and new list
| Business Title | Cleansed Role |
| Agile Coach | Agile Coach |
| Analytics - Data Scientist | Analytics - Data Scientist |
| Analytics - Developer | Analytics - Developer |
| Associate Software Engineer | Associate Software Engineer |
| Associate Test Analyst | Associate Test Analyst |
| Database Design/Admin | Database Design/Admin |
| Delivery Consultant | Delivery Consultant |
| UX Delivery Consultatn | Delivery Consultant |
| UX Designer | Designer |
| DESIGNER. | Designer |
| Consultancy_Specialist_Level_6 | Not on Rate Card |
| Architecture_SPE_LEVEL6 | Not on Rate Card |
| Systems Installation/De-commissioning | Not on Rate Card |
| User Support | Not on Rate Card |
| IT operations | Not on Rate Card |
| Applications support | Not on Rate Card |
| Consultancy | |
| Compliance | Not on Rate Card |
| Principal : Solution Architect/ Technical Architect /Enterprise Architect | Principal : Solution Architect/ Technical Architect /Enterprise Architect |
| Principal Solution Designer / Senior Solution Design Manager | Principal Solution Designer / Senior Solution Design Manager |
| Researcher | Researcher |
| Content Strategist | Researcher |
| Senior Database Design/Admin | Senior Database Design/Admin |
| Senior Designer_Std | Senior Designer |
| Senior UX Designer | Senior Designer |
| Senior UX Researcher | Senior Researcher |
| Senior Researcher_ | Senior Researcher |
| Senior Researcher | Senior Researcher |
| Senior Researcher/Senior Designer | Senior Researcher/Senior Designer |
| Senior Software Engineer | Senior Software Engineer |
| Senior Solution Designer | Senior Solution Designer |
| Senior Test Manager / Specialist Test Analyst | Senior Test Manager / Specialist Test Analyst |
| Senior UX Consultant | Senior UX Consultant |
| SFIA2 | SFIA2 |
| SFIA3 | SFIA3 |
| SFIA4 | SFIA4 |
| SFIA5 | SFIA5 |
| SFIA6 | SFIA6 |
| Software Engineer | Software Engineer |
| Software Engineering Team Lead / Principal Software Engineer | Software Engineering Team Lead / Principal Software Engineer |
| Solution Designer | Solution Designer |
| Specialist : Solution/Technical Architect | Specialist : Solution/Technical Architect |
| Specialist Database Design/Admin | Specialist Database Design/Admin |
| Specialist Software Engineer | Specialist Software Engineer |
| Specialist Solution Designer / Solution Design Manager | Specialist Solution Designer / Solution Design Manager |
| Test Manager / Senior Test Analyst | Test Manager / Senior Test Analyst |
| Junior UX Consultant | UX Content Strategist |
| Business Title | Cleansed Role |
| Analytics - Data Science | |
| Software Engineer | |
| Test Analyst | |
| Designe | |
| Designerr | |
| UX Design | |
I am looking to populate the blank 'cleansed role' fields using fuzzy match on Business Title.
