Similarity Match

[#1]

This macro is like the Fuzzy match tool and calculates a similarity match ratio using Python difflib's SequenceMatcher function. The difflib can calculate the similarity ratio by the Gestalt Pattern Matching algorithm. This macro outputs the S input data with the result of calculating the similarity ratio between the specified field of the S input and the specified field of the T input.

This macro has two options. One is that can output only the records with the highest similarity ratio. Another option is that output the records more than a threshold of similarity ratio that you set.

The detail of difflib function：https://docs.python.org/3/library/difflib.html

[AkimasaKajitani]

@MSzadowiak 

Sorry for the late reply, basically the macro which is used Python tool is needed to run for install python packages by Admin mode at first. This means that you need to run Designer by run as administrator. Normally, when you run the Designer, it will run non admin mode even if you installed the Admin Designer. So you should run the Designer by "Run As Admin".

[dvortsis]

Thank you so much for this! I've been using it for a long time and it has saved me a ton of work and frustration over the native fuzzy match tool. Excellent work!