Hi,
I’ve been trying to join the names of two databases and the problem is the that I lost a lot of names and just because of a letter o something very specific, is there a node o something that I can do to clean the names so when I join both database I lost the least information quantity?
It would be great!
Thanks.
wkhan
October 21, 2020, 11:44pm
2
Hey @LilianaGarcia ,
It sound like you’re asking how to to a LIKE join. Check out these Forum posts:
Hi @Cardinal_Fire ,
You can do this in KNIME by creating a dedicated joining column that just contains these first 7 characters. An easy way would be with the String Manipulation node, I have attached a workflow that demonstrates how to do this. Joining example.knwf (9.7 KB)
best,
Gabriel
What node I can use to join two KNIME tables by like criterion.
Ex. $Organization_T1$ like ‘$organization_T2’
Igor
Regards,
Wali Khan
4 Likes
ipazin
October 22, 2020, 12:01pm
3
Hello!
Adding more threads to check as this is frequent topic:
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…
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
1 Like
system
Closed
April 23, 2021, 12:02am
4
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.