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.