If I have 2 tables, and I want to extract the data present only in the Left table exuding the common data based on two columns. How can I do that.
In Joiner node, turn on option “Always include all columns” in “Bottom Input (right table)”
and turn off option “Remove joining columns from bottom input”.
Then Row Filter rows with missing value in right table_PrimaryID.
Thanks for you time Martin.
I tried doing that but I did not get the result.
Can you please share the workflow?
Sure, here it is.
Left_excluding_join_knime.zip (16.1 KB)
Wow! That’s awesome. Thank you very much Martin
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.