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

[MSzadowiak]

Hello all,

I tried to run the macro but I get an error I've not come across before. The excerpt goes like this:

Error: SimilarityMatch (49): Tool #3: Traceback (most recent call last):
File "c:\users\xxxx\local\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\runpy.py", line 194, in _run_module_as_main
return _run_code(code, main_globals, None,
File "c:\users\xxxx\appdata\local\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\runpy.py", line 87, in _run_code
exec(code, run_globals)
File "C:\Users\xxxx\AppData\Local\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\Scripts\jupyter-nbconvert.EXE\__main__.py", line 7, in <module>
File "c:\users\xxx\appdata\local\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\jupyter_client\kernelspec.py", line 235, in get_kernel_spec
raise NoSuchKernel(kernel_name)
jupyter_client.kernelspec.NoSuchKernel: No such kernel named designerbasetools_venv

I assume it has to do with either macro or Python settings on my desktop, but I can't get to the bottom of it. Any ideas?

Thanks in advance