To Find unmatched rows from 2 different tables

I have 2 tables

Table A and table B

Table A has 100 rows and table B has 100000 rows

80 rows of table A matches in table B

I need to find other 20

hi @navi1993 and Welcome to the KNIME world,

there is a specific node for this, which is called Reference Row Splitter.

you should have one column as identifier in each table, which will be compared.
Your workflow should look like shown here…
grafik

Greetz, Tommy

5 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.