if then else with multiple conditions
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