Near/Partial match of two columns from different files

[harish_alt]

Hello Alteryx community,

I am trying to achieve Near/Partial match of two columns from different files as shown below

File 1 :

Name

ABC

ABC ccd

xyz abc

abc, new

File 2:

Name

abc

xyz

abc, newly

Output (Insert a new column in File2) :

Name	SuggestedName(from file1)
abc	ABC
xyz	xyz abc
abc, newly	abc, new

Please guide me to achieve this Partial match/ Near match/Best match.

Thanks in advance

[messi007]

@harish_alt,

I'm not expert on the fuzzy match tool but hope this will give you some ideas.

I used Append fields in order to make both columns one beside one and used a fuzzy match to check the names for between both.

Attached the workflow,

Hope this helps!

Regards

[harish_alt]

Hi @messi007,

Thanks for the quick response.

This workflow is not giving the 'Best Match'.

For example:

for 'ABC', we need to get 'abc' as the suggested name. But it is giving 'ABC ccd'/'ABC new'(as matching score is 100) which is not the nearest match.

Thanks