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
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?
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
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