if then else with multiple conditions

[sgknime]

Hi there

I am new to knime and try to migrate workflows from SPSS Modeler to KNIME. I stuck on applying a derived field:
How can I derive (create) a new variable by using if then else with multiple conditions on existing columns? Which nodes are best for the following example?

if (var1 > 0 and var2 > 0) or (var3 + var4 > 0) then 1 else 0 endif

I tried different nodes (column expression, rule engine, math formula) but wasn’t able to make it work.

Thanks for help or a hint.

Best regards, Sinan

[Experimenter]

For simple comparison rules you can use Rule Engine node. It will not allow you to sum up something, however - so you need to do your calculations prior to rule engine using Math node.

[izaychik63]

See syntax examples here JavaScript AND OR in IF Statement to Check For Multiple Conditions
Use Variable Expressions — NodePit
for variables or
Column Expressions — NodePit
for table cells.

[ipazin]

Hello @sgknime,

and welcome to KNIME Community!

For Rule Engine if else logic see here:

If else in rule engine

How to apply if else in rule engine?

For Column Expressions if else logic see here:

COLUMN EXPRESSION: IF ... else

Hello…I am new to KNIME, not new to IT. Can you please help with syntax on this pseudocode IF col1 = ‘ABC’, then col2 * 10 else min(col4, col5)*col2 * 10/2 end I am completely confused with various {[(, to be manipulated there… Thanks!

For Math Formula if else logic see here:

IF STATEMENT

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: Br, Ivan

In your case I would go with Rule Engine

Br,
Ivan

[sgknime]

Thank you very much to all of you for your answers and hints and links. After that I think it’s best to go with the rule engine. I can rewrite my logic though I was interested how such a simple comparison could be done 1:1 in KNIME.

Thanks again!
BR, Sinan