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