Rule-Based Row Filter; how filter out data

Hi, new to Knime here, looking to filter out data, one of my columns has two “names” that I want to filter out, so basically $Name$ is NOT equal to “manager” and $Name$ is NOT equal to “System Admin”

how do you write a “not equal to” statement in a rule-based row filter?

You ca use equation without NOT and the option - Exclude TRUE Values
or Use NOT $Name = “manager” OR NOT $Name$ = “System Admin” => TRUE

thank you, but this is the error I received… "invalid settings: Line 5, col 13: expected a number, string, column, a table property or flow variable reference

It is the copy/ past issue. Delete quotation marks and input them from keyboard.

1 Like

PERFECT! THANK YOU SO MUCH!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.