Quick help with fuzzy matching %

[Isha_Gupta]

Hey, 

I have a simple case with 5 columns.

Column A has unique IDs.

Column C and Column E contain names of companies from 2 different sources.

I need a matching % in Column F between Column C and Column E.

Thanks

[ChrisTX]

Try the option for Output Match Score

 

Chris

[Isha_Gupta]

Using it but where to select those 2 columns

When adding in the field name,  11k rows are getting converted to 48K or something 

[ChrisTX]

The Fuzzy Match tool may be creating a separate record for each word, depends on the configuration.  Difficult to determine without a sample workflow.

check out this video: Fuzzy Matching for Beginners - Alteryx Community

and the workflow attached to this post: Fuzzy Matching - Intermediate Users - Alteryx Community

and the Tool Mastery article: Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung (alteryx.com)

Chris