Multiple math calculation

KNIME Analytics Platform
1

Hi,

I would like to know if it is possible to do multiple math calculations and simultanelously append new coulmns in a single node?

For eg: consider this as my input column

C1 C2 C3
5 10 15
3 6 9
2 4 6

and I want to get the output as follows. with C4 = (C1)*2 + C3

C5 = C1 + C2 + C3

C6 = C1 - C2 + (C3 * 6)

C1 C2 C3 C4 C5 C6
5 10 15      
3 6 9      
2 4 6      

so is it possible to get the three outputs in a single node?

Thanks

2

This is only possible with the java snippet. The math node currently supports only one output column.

3

Okay. Could you please help me out with the procedure and syntax? Thanks

4

Hello nakuld,

I am not quite sure why you need all three in one. If it just to keep the workflow small you could use a Meta Node (right-click -> Collapse into Meta Node.

Attached you will find a small workflow demonstrating three ways to do these calculations:

  1. Meta Node
  2. three Math Formula
  3. Java Snippet

Best,
Ferry

5

Thank you very much Ferry.