Problem with names in data preparation

[ipazin]

Hello!

Adding more threads to check as this is frequent topic:

Name Comparison and Matching

Hi everyone, I’ve been searching, but haven’t found a solution to what I need (I apologize if there is an answer already). I’ve read about fuzzy matching, string similarity, the Levenshtein algorithm, but I don’t think they apply to my problem. I have two tables with names, and I need to compare and find the matches between them. The problem is that the names are not exactly the same between the databases: from one I can get the full name and surname, while the other has only the first lette…

Comparing Letters

Hi!!! Knime Experts Hope you are doing well. Just need your help to compare certain words, so that i can progress in my workflow. Requirement: Input: Name of Vendor: Qwerty Private Limited Qwerty Private Ltd. Qwerty Pvt. Ltd. All the three name is for single vendor, but in KNIME it’s showing 3 unique name, what steps shall i use or what changes shall i do that knime would consider all 3 as same. Thanks in advance.

Br,
Ivan