String Comparison

Hi,

I am trying to compare following two tables.

Table 1
Guest
James
Jamerson
James Inc

Table 2
Participants
James Choo
James Cole
Jame
James & Sons
Lou Jamerson
I am struggling with which node to use.

If i use Joiner or Rule-Base Filter to identify how many Guest were part of Participants i only get absolute match (say James = James) but doesn’t get like mathces (say James = James Cole or James Choo)

Since i am comparing two list of values single Row Filter or Rule Engine will not do the job.

any suggestions???
Jessica

Hi @Br1jesh

I think of using a cross-joiner and after that the String Similarity node.
string_sim

gr. Hans

3 Likes

Thank you HansS.

do you know how to use Rule Engine and Rule Engine Dictionary to solve this issue?

Ultimately i would like turn each value in my table 1 to a rule and compare it with table 2.

any suggestions?

See this example workflow KNIME_project4.knwf (34.3 KB) with two options. Hope this helps.


gr. Hans

1 Like

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