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
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_mainreturn _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_codeexec(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_specraise 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
@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".
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!
