Column comparator operator

KNIME Extensions
1

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

2

Does this help?

1 Like
3

Hello @LeaKB,

see this topic:

Br,
Ivan

1 Like
4

Thanks, Ivan, this is great!! I am just wondering - for 2 exact same strings, I get a value of 0,9142… which should be a 1 obviously. Why is that, what do you reckon?

Many thanks,
Lea

1 Like
5

Hi @LeaKB,
it could be that one of them countains additional space or nonprintable characters. Maybe a simple length check can clarify it.

BR

1 Like
6

I have used strip() and now it works, thanks!!

1 Like
7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.