IF STATEMENT

[SimoneDePaoli]

Hi all,

i’d like to be able to use IF STATEMENT that allow me to make this formula:

• a= 1 column
• b= 2 column
• c= 3 column

if a > b then d = c * b
else
b

may someone help me to understand which node is better to use?
thank you in advance.

simone

[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