Fuzzy Match to ignore some words

Marp

Hi All

Hope you are going good!

I am trying to perform Fuzzy Match between 2 files by ignoring some works ( like.. LTD, inc, corp ..etc) and also punctuations.

i am attaching the flow with fuzzy match and the Score is still not 100

please help

Thanks

R

FuzzyMatch_Names_.yxmd

KilianL

Hi @Marp ,

nice to see a good fuzzy matching workflow.

Not sure why the Fuzzy Match settings didn't pick this up.

I did it manually using the data cleansing and a formula tool to strip punctuation and remove INC and LTD. Changing the case to upper case did the trick for me to reach a score of 100.

See attached.

Please mark this as the solution if it answers your question, it will help others to find solutions quicker.

Kind Regards,
Kilian
Solutions Engineer - Alteryx

FuzzyMatch_Names_.yxmd