Hello Knime Fans,
I am trying to figth with one XLS table and one simple math rule. The idea is:
1. I have a xls table with 3 columns: Product Number | Rating | Scores
For example: 1 | 10 | 40
2 | 12 | 80
3 | 15 | 70
2. This table is cnaging everyday, so I want to check it and IF the Scores are over 60, the Rating of the Product have to be increased with 33%.
IF Scores(Product1) > 60
THEN Rating(Product1) = Rating(Product1) + Rating(Product1)*33/100
3. Update the new result in a table.
I tried with Math Formula but I couldn`t find If statement with an action, I found If statement with writing 1 or 0 in a new column.
How can I make it in Knime?
Can you help in this, please?