Group rows by String Distance

[ipazin]

Hi there @morelator,

welcome to KNIME Community Forum!

Here is a simple workflow example which can get you started:

Clustering Strings – ipazin

The thing that is left for you is to define rules in order to deduplicate dirty elements. You can use Rule Engine for this or GroupBy node if majority always wins…

You can check this topic as well:

pattern analysis

https://forum.knime.com/t/pattern-analysis/14654/4 Hi guys, I have a question regarding the approach that was mentioned in the workflow shared in the link above. The part where the columns where combined is really helpful, but I have troubles regarding the positive. @mlauber71 mentioned some ways to do so, but could you help me out by doing this without a positive list, because my dataset is to big so therefore it is impossible to create a positive list manually. Which nodes can I use to take…

Br,
Ivan