How to multiply the one column value to other all right column

Hi I would like to multiply the one column value to other all right column

For example ,Always Column3 is IT/CS number, and multiply with other right column
Column3 Column4, Column3 Column5, Column3*Column6…etc

Column1 | Column2| Column3 | Column4| Column5|Column6
ProductsA| | 5| 20| 50| 10
ProductsB| | 10| 20| 50| 10
ProductsC| | 1| 20| 50| 10

↓After KNIME

Column1 | Column2| Column3 | Column4| Column5|Column6
ProductsA| | 5| 100| 250| 50
ProductsB| | 10| 200| 500| 100
ProductsC| | 1| 20| 50| 10

I would appreciate your help!

Hi there @erisu,

you should use Math Formula (Multi Column) node to achieve this. Include columns that need to be multiplied and use this expression:

$$CURRENT_COLUMN$$ * $Column3$

Make sure to check Replace Selected Columns and Convert Selected Columns to Int options at the end of configuration dialog if needed.

Br,
Ivan

6 Likes

Thank you very much! It worked!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.