Join 2 tables by taking only the row values not in common

Hi collegues,

I would like to join two tables by taking only the row values that are not in common. In a certain sense I would like to get all the data that are not in the intersection between the 2 table. The left outer join and the right outer join unfortunately get also the values in the intersection, so it's not good for me.




Is it possible in Knime?

Thanks in advice.

Hi, seems like you should use the Reference Row Filter and exclude matching rows of the reference input (table 2).