Filter - Not Like

Team -

Within a dataset, I have a column (employee ID) that contains alpha numeric six character variations of each employee identifier. Some are fictitious and start with N-. I need a way to filter these records out of my dataset. I can’t seem to find a not like function in Knime. Can anyone suggest a method for solving this problem?

Thanks - Ryan

node supports not like.

6 Likes

@izaychik63

Thank you

Hi @rhowlett , in addition to @izaychik63’s suggestion, the standard Row Filter node can also achieve “not like", by excluding rows based on a pattern match which can be based on wildcards or regular expressions

5 Likes