math formula for all adjacent columns

[jalilsh]

Hi,

I have a data table with several data columns (e.g. c1, c2 , c3, …, c10). I need to calculate difference of every 2 adjacent columns and place the result in a new column:

c11= c2-c1
c12= c3-c2
.
.
c19= c10-c9

since i am not familiar with Java or Python, is there an straight solution in KNIME for this calculation. if not , i appreciate if anyone may help with java or python smany thanksnipets.

many thanks

[ipazin]

Hi there @jalilsh,

not a solution you can easily think of but this idea from @AlexanderFillbrunn makes this task pretty easy using Column Expressions node. It was about multiplication of 2 columns with step 2 so you’ll need to modify expression a bit.

Math Formula (Multi Column)

Hello, I would like to ask you how to calculate some basic mathematic operation for more than one column. Example: need to calculate following columns: Split1Split2 Split7Split8 Split10*Split11 etc. I can use Math Formula nodes, but in this case I have to use it many times separately and that is not convinced or use Math Formula (Multi Column). Am I right with Math Formula (Multi Column)? But I tried a lot of approaches to configure Math Formula (Multi Column), but no success. Can someo…

Give it a try and if you’ll need help drop me a message and I’ll create an example

Br,
Ivan

[jalilsh]

Hi @ipazin,

thanks for your reply. That was a very nice solution.

BR