Near/Partial match of two columns from different files

Question

Hello Alteryx community,

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

File 1 :

NameABCABC ccdxyz abc

abc, new

File 2:

Nameabcxyzabc, newly

Output (Insert a new column in File2) :

NameSuggestedName(from file1)abcABCxyzxyz abcabc, newlyabc, new

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

Thanks in advance

harish_alt · Answer

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

messi007 · Answer

@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

Fuzzy_20210430.yxmd