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
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.
