Hi All,
I hope everyone is staying safe and are doing well.
I have a question with regards to a piece of data that I have. Bascially I have two piece of information in my data company name and Attendee name and both of these are spelled diffrently in most of the records.
For example in the below table, even though the company is the same ABC it has been flagged off diffently in all the four records and similarly the attendee name looks similar they have been spelled differently.
| Company Name |
| ABC |
| ABC Standard |
| ABC Standard Life |
| ABC Standard Investments |
| Attendee Name |
| Mihir Desai |
| Meher Desai |
| Andy Desai |
| Andrew Desai |
Is it possible to create a mapping table where I can create a new column for company name taking into consideration the company's first word ignoring the last name or the suffix used in the company name.
| Company Name | New Company Name |
| ABC | ABC Standard life |
| ABC Standard | ABC Standard life |
| ABC Standard Life | ABC Standard life |
| ABC Standard Investments | ABC Standard life |
Similarly for Attendee name.
| Attendee Name | New Attendee name |
| Mihir Desai | Meher Desai |
| Meher Desai | Meher Desai |
| Andy Disai | Andrew Desai |
| Andrew Desai | Andrew Desai |
