Unable to do custom comparison levels with non exact match sql statements

[mmagoffin-sd]

I was trying to create a custom comparison level for looking at first names by seeing if a canonical name matched with a first name that was a nickname given in my data. However, since I was doing a LIKE statement in SQL, I didn't need a term frequency column. When I try to run linker.estimate_parameters_using_expectation_maximization I get a BinderException about a tf_canonicals_fname_l column that shouldn't need to exist. I tried both a different SQL statement (jaro_winkler_similarity(str_l,str_r) < 0.8) and attempting to add a term frequency column based on my fname column within the comparison. Both the custom comparison level and the error are in screenshots below:

[RobinL]

Sorry for the bug - I think this was fixed in version 3.3.5 here so if you upgrade pip install --upgrade splink this problem should go away. Let me know if it doesn't!

[mmagoffin-sd]

Looks like it fixed the problem for running the estimate_parameters_using_expectation_maximization() function, but now I get the same error on linker.predict()

Thank you for the quick responses!

[RobinL]

Please could you upgrade to 3.3.7 and see if it works. I've added a test here with your specific example, so it definitely should work now!

[mmagoffin-sd]

That worked, thank you!