IF statements in Knime

[danielvorster]

Hi there.

Is there a way to do something like this in knime?

=IF(T2<0,T2,0)

So what I want any values >0 in a column and if the value is less than 0 then it should return 0 and vice versa

Any help would be greatly appreciated

[danielesser]

Hi @danielvorster,

one potential solution is using the Rule Engine node for this:

Rule Engine — NodePit

Specify the rule as follows (e.g. $Price Change$ is your column) and append the result to a new column.

$Price Change$ > 0 => $Price Change$
TRUE => 0

Best regards,
Daniel