This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to make a fuzzy match row by row between 2 company name fields and in general it is working find. I am using "Double Metaphone" method.
However I donot understand how come Id 1 and 6 doesnot find any match. I have listed "AND OF THE CO INC AS IOOO SRL FLLC CORP LLC LLP LTD GMBH KG OOO" in the Don't Generate Keys for the following words" section. But I think they are not ignored.
Result seems to be working. However now this model is matching all possible names in same column. However I would like to make sure only 2 name column within 1 row is matched. Therefore Id field should be incorporated in fuzzy match. Don't you think so?
Imagine there is an id 7 with name1= LLC TELTACOM and Name2= TELTECUM LTD. I don't want this to match with values in id1.
However if you add name1= LLC TELTACOM and Name2= TELTECUM LTD as row 7 they still match with values in row 1. I have amended the workflow and attached which I think working fine now. However if I can come with a solution without filter tool at the end it can be nice. Any ideas about that?