Using Rule Engine to label data

[jmckenna23]

Hi, my problem is that I am unable to label data based on a rule-base which goes like this:
NOT $result_value$ LIKE “positive” OR NOT $result_name$ LIKE “positive”

The goal is to label all rows with the matching pattern as ‘NEGATIVE’ if the row does not contain the matching pattern ‘positive’ within these two columns. Using NOT does not seem to work. Does anybody have any explanation on this or able to resolve this issue?

[aworker]

Hi @jmckenna23

My first suggestion to your logical rule would be to write it as follows:

@jmckenna23

NOT ($result_value$ LIKE “*positive*”) OR NOT ($result_name$ LIKE “*positive*”) => TRUE
TRUE => FALSE

Writing the logical rule with parenthesis makes sure what should be evaluate first and how.

Besides this, the logical rule that you have written is equivalent to:

@jmckenna23

$result_value$ LIKE “*positive*” AND $result_name$ LIKE “*positive*” => TRUE
TRUE => FALSE

A and B is equivalent to NOT A or NOT B in boolean logic but the former is easier to read.

Hope it helps.

Best
Ael

[lelloba]

Hello @jmckenna23 ,

have a look at this workflow:

Using rule engine to label data – lelloba

Tell me if it helps.

Have a nice day,
Raffaello
Linkedin