IF STATEMENT

[ipazin]

Hi there @SimoneDePaoli,

in this case I would use Math Formula node and if() function cause you have numeric columns.
This would be syntax:
if(a > b, c * b, b)

In case you are looking for some more complex if/else statements or string columns are included see this topic about Column Expressions node:

Need Help with a Simple IF THEN Statement

I am trying to do a simple if-then calculation such as: IF [Column A] = 4 THEN [Column B] * -1 ELSE [Column A] I want to take a price column and make it negative for returns. I have looked at the Rule Engine, Column Expressions, Java Snippet, Column Lag, and other nodes, but it is still not clear how to make this simple calculation. Can some please offer any suggestions? Thank you.

Br,
Ivan