Comparing Tables

KNIME Analytics Platform
#1

Hello,
I have two tables with different columns.
lets say there is p_Id in table one and q_id in table two.

lets say that p_id is the reference and most of them are unique.Hence want to the resultant table to have the columns where p_id is not equal to q_id( even the duplicate q_ids should not be in the end table)
How can i compare them? I want to do them only with the IF conditions as i have some other operations to be performed on basis of IF
Thanks.

#2

Here’s KNIME video explaining how filtering works.

1 Like
#3

Try a Joiner node with left outer join, joining p_is to q_id, followed by a row filter, keeping rows only with missing values in q_is

Steve

1 Like
#4

Thanks roughley.
But I am specifically looking at using of conditions on columns for two tables for different reasons.
Can you please help me with that