Rule Engine IN condition

I have two different tables and I would check if any element of a column in the first table exists on a column on the second table.

I’m trying to use the ‘IN’ condition but I cannot select the table of the second table as the second element of the rule.

Thanks

Welcome to KNIME forum. Please see discussion below.

Let us know if it helped you.

1 Like

Hi @deplanoa -

Welcome!

Another node you might try is the Reference Row Filter.

Hi, thanks for the answers but doesn’t solve my problem, probably my explanation wasn’t clear.
I have 2 table with one column each.
Table1
A
B
C
D
E
F
G

Table 2
E
G
C

what I need is add a new column on table1 with TRUE or FALSE if the value of table1 exist or not in table2.

Thank you.

Hi @deplanoa

I suggest just join both tables (keep both columns!) and check with the Rule Engine node if the values are the same . See this example match2tables.knwf (17.5 KB)

gr. Hans

3 Likes

It works perfectly!!

many thanks

2 Likes

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