How to create mapping table

[mihir_mir_jb]

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

[Qiu]

@mihir_mir_jb 

You may want to look at the Fuzzy Tool, though it requires some tuning.

[mihir_mir_jb]

I am actually at a very adolescent stage when it comes to Alteryx.

[Qiu]

@mihir_mir_jb 
Tried one sample but note the fuzzy match still requires some tuning of Match Threshold parameter.

[afv2688]

Hello @mihir_mir_jb ,

I just played a little to create some matching keys (it's not perfect), hope this helps you:

Regards