Mining Text in Rows

I am would like to search each row of one table (Table 1) with each row from another table (Table 2).  

Table 2 contains a list of words that I would like to serach Table 1 via regular expression.

  • The row filter node only allows me to search Table 1 using only 1 row from Table 2 as a regular expression.
  • I could start a loop, but is there a better way?

I think you need to go through a chunk loop and process one row at a time; especially when you want to apply a regular expression on each individual rows.

In terms of needing regular expression, Gabriel’s method sounds the best.
If its exact matching, then the reference row filter node and configuring to include will do this quick and easy but no support for wild card or regular expressions, only exact!
Simon.