Hi, I have another question (sorry, probably basic again…): I need to compare one column with 4 others (street names). In this particular column, sometimes the street names are not complete or contain mistakes whereas in the 4 other columns they are correct. I am using 4 column comparators with the operator “==” and the tags TRUE and FALSE. After that, I am using a Rule-based Row Filter ($comp_Strasse 1$ = “TRUE” OR $comp_Strasse 2$ = “TRUE” OR $comp_Strasse 3$ = “TRUE” OR $comp_Strasse 4$ = “TRUE” => TRUE). It doesn’t work though for example for: Alxingerg vs. Alxingergasse Porzelangasse vs. Porzellangasse Zum Weißen Storch vs. Zum weissen Storch Richard Strauss Str vs. Richard Strauss Straße Absbergpl vs. Absbergplatz Is there an operator for not exact matches but similar which is exact enough for my purposes? Or any other way? Many thanks, Lea

Hello @LeaKB , see this topic: [image] Finding similar names KNIME Extensions Dear all, I have a large table with >10000 names/spellings in one column containing names which differ slightly for different persons for example: Mickey Mouse M. Mouse Mouse Mickey M. Disney Mouse M. Dinsey Muose I would like to find somehow groups of similar names in order to construct with minimal manual effort a dictionary replacer replacing finally all of the above names by Mickey Disney Mouse, for instance. Any idea how to this? Thanks Jerry Br, Ivan

Column comparator operator

KNIME Extensions

ipazin May 28, 2021, 9:04am 3

Hello @LeaKB,

see this topic:

Br,
Ivan

1 Like