Nested IF Function. Math Formula Node

KNIME Analytics Platform
1

Hi there I wonder if it might be possible to make a Nested IF function, with the Math Formula Node. I tried with a "code" with the logical function if(x,y,z) but I the output is an empty column.

if($A1$>1,"YES","NO" )

I want to obtain YES if the result is True and NO is the result is False.

On the other hand, I wonder how can I make a Nested IF function, done in Excel, of this kind (I am pasting the Excel Formula).

 


=IF(AND(VAR1<1,VAR2<2,VAR3<5),"VALUE1",IF(AND(VAR1<5,VAR2<7,VAR3>43),"VALUE2","NOVALUE"))

Thank you

 

 

 

 

 

 

 

2

The Math Formula node is meant for simple expressions only. If you have complex expression (such as nested ifs) then I suggest you use one of the Java Snippet nodes.

3

Other option might be the Rule Engine/Ruleset Editor (assuming you do not want computations in the result).