Question about Anti Join

KNIME Analytics Platform
1

Hi all~

Write a message because of a problem during data preprocessing.

Here are two tables.

1. Table

Col1 Col2
A 20
A 80
A 20
B 100
B 30
A 100

 

2. Table 

Col1 Col2
A 20
A 100

1. Table needs to refer to 2. Table and create 3. Table result.

3. Table

Col1 Col2
A 80
B 100
B 30

In summary, I would like to exclude the values by considering Col1 and Col2 at the same time.

Please let me know if someone knows the solution.

 

 

2

Use Reference Row Filter with exclude option.

3

When you use the Reference Row Filter, only one Col is considered

So, Can't get the above 3.table results.

Someone please help me

4

Hi mois,

than you need to use two and concatenate the result.

Best, Iris 

5

Hi iris

Thank you very much.

^^