Hi everyone!
I trying to get a output by matching these Two Columns and Get a Output where its matching.
Tried Using Fuzzy match tool with a common column with record ID but For some reason the output is not I execpted.
Points to be considered for it to match:
- Exact matching i.e ( word to word match )
- Abbreviaitons LTD - Limited , CO - Company I, INS - Insurance , INC - Incorporation
- punctuations
- inclusive for words like brach , Group
Points to be considered for it to Not match:
- Extra Words
- Contains Country codes such as LA , IN
For the below table , Except the one's in Italic and underlined all should be a match.
Have tried out with Fuzzy logic with Company Name template and Im not able to Get the Exact output, attaching the workflow that i referenced.
My Expectaions and queries are:
- Is there a proper way to use fuzzy logic wo create a match using custom template?
- Is there any other tool which will help me match these Two Column's
| S&P company names | Applicationcompany names |
| InBev | In Bev |
| Abbott Laboratories | Abbott Laboratories LA |
| AbbVie | AbbVie |
| Accenture | Accenture, IN |
| China Resources Land | China Resources Land/The |
| China Railway Engineering | China Railway Engineering |
| China Resources Land | China Resources Land |
| China State Construction Engineering | China State Construction & Engineering Limited |
| Cigna | Cigna INC |
| Cisco Systems | Cisco Systems Branch |
| CITIC | CITIC The |
| Citigroup | Citi group |
| Coca-Cola | CocaCola |
| Comcast | Comcast |
| Costco Wholesale | Costco Wholesale |
| Credit Agricole | Credit Agricole |
| CVS Health | CVS Health |
| Daimler | Daimler Cements |
