Substraction of two tables

KNIME Analytics Platform
#1

Dear all:

I am trying to perform the substraction of two tables with identical structures (i.e. row and columns numbers). What I wan to do is to substract the value in each cell from table 1 and table 2, and produce a new table with the residual values? Is there a specific node to accomplish that procedure?

thank you very much in advance

best regards

 

Alfredo

     

#2

What I am actually trying to do is to substract the numerial values in the cells of each table, to get a new table containing the same number of rows and columns, but containing in each cell the value corresponding to the subtraction of that cell in Table 1 - that cell in Table 2. 

best regards

#3

Hello Alfredo,

I am not aware of a node that does this, or a nice solution, but I hacked something together. It should do what you requested.

Best,
Ferry

Column Compare from 2 files
Column Compare from 2 files
#4

Thank you very much Ferry for your response and for providing me this elegant workflow. It aparenty performs what I am trying to accomplish, but it works only for integer values, since fraccional values are rounded. Is tere any workaround for this issue?

 

thanks again for your valuable help,

 

best regards

 

Alfredo

#5

Hello Alfredo,

You have to uncheck "Convert to Int" in the Math Formula node.

Best,
Ferry

#6

Ferry, it works perfect now! 

Thank you very much

best regards

 

Alfredo

#7

The Reference Row Filter node is what you are looking for.

Misunderstood the question. Sorry for the wrong advice.