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.
@tshrprk check out this workflow for an example. I added some comments to hopefully help explain why I added the tools I did and configured them in the way I did.
@tshrprk I was wondering if this got you what you needed - I hope it helped!