Need Multi Row Formula

KNIME Analytics Platform
1

Hi everyone,

 

I need to compare two tables I have, to get the third table. The condition is that If Col1.Table1==Col1.Table2 AND Col2.Table1==Col2.Table2 AND Col3.Table1!=Col3.Table2.

For instance:

Table 1: 

      Name    Category        Date     

1)   X             A                     1/1/2001

2)   Y             B                      2/15/2004

3)   Z             C                      5/20/2014

 

 

Table 2:

      Name    Category          Date     

1)  X             A                      1/31/2001

2)  Y             P                      3/15/2004

3)  Z             C                      5/20/2014

 

Resultant Table:

       Name    Category          Date     

1)   X             A                      1/31/2001

 

So here in the above example I have only one record in the resultant table where Name and Category are same but Date is different.

I need a workflow for this, I tried Math Formula but result wasn't as expected.

 

Thanks.

2

Hi Nagaraja,

You can do this by using a Joiner node to do a full outer join on your first two columns. Next, you use a Rule-based Row Filter to select rows in which the content of the third column is different.

Cheers,

Roland

3

Thank you so much Roland.