Search for keywords in a couple fields (REGEX maybe?)

[ipazin]

Hi there @stevelp,

this topic might help. Also includes references to other same/similar topics as well.

row filter

I have 2 tables and each has one column, I want to filter out rows in the first table in which column value contains any value in column of the second table. Example: Table 1 Rowid Column 1 this is the first row 2 this is the second row 3 this is the third row … n this is the nth row Table 2 Rowid column 1 second 2 fifth my desired result will be without row 2, 5. any suggestions to handle this?…

Considering you have “no experience with regular expressions and little with KNIME” I don’t think a bit of learning would do any harm Apart from this community KNIME provides lot of resources here:

Resources | KNIME

Good luck and if any questions feel free to ask!

Br,
Ivan