Hi all. I’m new to Knime, hope someone could help in understanding some basic features. I’m trying to group strings in a column within a table by evaluating the string distance. See image for further details. This is a very rough idea of my goal. The general concept is to define some rules in order to deduplicate dirty elements. In this simple example the first column should represent all possible entries. They are not really already grouped, it’s only for sake of comprehension. They arrive as input randomly. Does someone has a very basic workflow to understand the process? Something easyer than in https://www.knime.com/blog/address-deduplication . Thanks in advance [immagine]

Hi there @morelator , welcome to KNIME Community Forum! Here is a simple workflow example which can get you started: [image] Clustering Strings – ipazin This workflow performs assigns clusters based on Hierarchical Clustering for one string column using Levenshtein distance. 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: [image] pattern analysis KNIME Analytics Platform 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

Group rows by String Distance

KNIME Analytics Platform

izaychik63 August 12, 2019, 12:37pm 2

Look here

for ideas.

2 Likes