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

KNIME Analytics Platform
1

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.

Table_1:{1,2,3,4,5}

Table_2:{1,3,4,7}

Table_result:{2,5,7}

Is it possible in Knime?

Thanks in advice.

2

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