Match 2 Set of data and find the non matching datas

Hi All!!
I’m very new to knime and have interest to know the utilization of the same for learning purpose. I was working with 2 SET of data where the customer ID is the Primary Key and I want output of non matching customer ID with their other relevant fields.
Can you help me to find out the same with the nodes which I need to use?

Regards
Bishwajit Dey

You can use Join Node using primary key as matchingg key.
Set join type as left join.
Now append a row filter node selecting only rows where right table have missing values in primary key.

Hi there @BISHWAJIT,

welcome to KNIME Community!

You might find Reference Row Filter node useful in this case.

Br,
Ivan

1 Like

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