difference between two different table with key column

[asgharkazemi]

hi every body
I have two different table(for example A and B) but with a key column in both of them. I want to have a table, contains rows from table A that they aren’t in table B. for example :
table A----------------------------------------------table B
key column-----column1—column2--------- key column—column3----column4
10--------------------ex1---------ex8 -------------10-----------------ex15--------ex20
11--------------------ex2---------ex9--------------12-----------------ex16--------ex21
12--------------------ex3---------ex10------------14-----------------ex18--------ex23
14--------------------ex5---------ex12------------16-----------------ex19--------ex24
15--------------------ex6---------ex13
16--------------------ex7---------ex14

I want this:(A-B)
key column-----column1—column2
11--------------------ex2---------ex9
13--------------------ex4---------ex11

[ToDi09]

Hello,

what you need is a join to get all rows which are in both tables (A + B) and then use reference row filter where you exclude all rows from the reference (A) and will get (A - B).

TomKNIME_project.knwf (19.1 KB)

[asgharkazemi]

hi again.
thank you very much. it helped me a lot.
wish you the bests.

[ipazin]

Hello there!

the new Joiner node - Joiner (Labs) gives you desired result without need of additional node.

Welcome both to KNIME Community!

Br,
Ivan