Question about Anti Join

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.

 

 

Use Reference Row Filter with exclude option.

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

Hi mois,

than you need to use two and concatenate the result.

Best, Iris 

Hi iris

Thank you very much.

^^