Hi all, how can I handle that Problem: [image] These rows belong together but because it is written in different ways, it is not possible to bring them together. i did some preprocessing but there are still Problems like the attached Picture. the Right column Shows the occurrence, here i used the Group by node to know how often one Name occurs. The problem is just that I dont have the Right Name, so I have no way to allocate these names to one right name. Do you know with which nodes can handle that Problem? Thanks and cheers, Canan

See also great solution here: [image] Renaming a string in a row based on another column KNIME Analytics Platform Another option if you’re not confident all companies will have a count above your cut off or if they might have multiple spellings above your cut off would be to use a clustering approach. If you use hierarchical clustering you can set a string distance cut off instead of a cluster number. After everything is clustered you can group them by the most common spelling and sum of counts. Attached an example below. You can see how close the spellings are in string distance to each other in the hiera…

Nodes to bring rows together

KNIME Analytics Platform

izaychik63 April 18, 2019, 6:51pm 6