How to get Left Excluding Join?

Hi,

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.

Example:

Table1
PrimaryID SecondaryID
A W
A X
A Y
A Z
B W
B X
B Y
C Y
C Z

Table2
PrimaryID SecondaryID
A W
A X
B W
B X
C Y
C Z

Resultant Table
PrimaryID SecondaryID
A Y
A Z
B Y

Hi,

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.

Martin K.

1 Like

Thanks for you time Martin.

I tried doing that but I did not get the result.

Can you please share the workflow?

Thanks again.

Hi Nagaraja_Ganiga,

Sure, here it is.

Left_excluding_join_knime.zip (16.1 KB)

2 Likes

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.