Is there a way to remove rows from a table that contain strings found in another table? The article below is very close to what I want to do, but it’s an exact match removal rather than removing all values that contain. For example, if my main table has the following values: nike shoes running shoes tennis shoes hiking boots And my table for things to remove has “shoes” in it, only ‘hiking boots’ would remain. Continuing the discussion from How can we remove the rows after checking with the another table? :

[image] Topic Extractor Node KNIME Extensions First we lowercase to get the best possible matches as upper and lowercase letters are not the same for computers. Then we use a little regex joining all the search terms together with | (which means “OR” in regex). Search for the word apple or dog ==> apple|dog Similarity Search 2.knar.knwf (52.0 KB) [Screen Shot 2022-04-05 at 12.06.03 PM] [Screen Shot 2022-04-05 at 12.05.48 PM] This solution actually works better on this sample of data, but if you have a lot of misspellings, this won’t… Will this solution work for your case?

Remove rows that contains values from another table's column?

KNIME Analytics Platform

badger101 May 24, 2022, 2:54pm 5

Will this solution work for your case?

5 Likes