not equal in rule engine

KNIME Analytics Platform
1

Hi there

how can i add an operator which means NOT EQUAL to a value not to a column?

e.g. i want to say $column A$ =/ “11” OR $column A$ =/ “10” => “Ko”
$column A$ = “11” OR $columnA$ = “10” => “Ok”

the function NOT $column A$ = “11”… seems it doesn’t work

thanks in advance

2

Mind sharing some more details? In general negating works with NOT. From the code snippets you posted do you maybe have number types in your columns and compare to strings?

3

Since only 10 or 11 are OK and the rest is “KO”, you could also write:

$column1$ = "11"  OR $column1$ = "10" => "OK"
TRUE => "KO"

The TRUE is the default fallback value here as per the syntax of the rule engine.

2 Likes
4

Hello @Pippobaudo89
These scripts may be valid for your use case (check out column type):

NOT ($columnA_numeric$ = 10 OR $columnA_numeric$ = 11) => "Ko"
TRUE => "Ok"

NOT ($columnA_string$ LIKE "10" OR $columnA_string$ LIKE "11") => "Ko"
TRUE => "Ok"

alternatively @ArjenEX approach is easier, check string syntax as well:

$columnA_string$ LIKE "10" OR $columnA_string$ LIKE "11" => "Ok"
TRUE => "Ko"

BR

2 Likes