Specific Row Filter

[bluena]

Hello,

I have a Table A with Company names that I want to filter rows based on keywords in Table B.
The keywords in table B are in two different columns.
The filtering shouldn’t be an exact match, but rather is one of the value in table B contained in the name from table A.

Ex:
TableA.Name
abc car factory USA
xyz apple factory
ZZZ

TableB.Column1
car factory
HDT mouse

TableB.Column2
Food
mouse
ZZZ

---

Result
TableA.Name
abc car factory USA
ZZZ

(I tried with no luck row filter regex/wildcards, Rule egine, Row filter - Reference Engine.)
Thank you for your help! Much appreciated!

Bernard

[HansS]

Hi @bluena / Bernard

I was thinking of a workflow like this specific_row_filter.knwf (35.0 KB) . Hope this helps.
gr. Hans

[bluena]

Thank you for the answer. Looks good! Will mark your solution as answer when I’ll be able to test it properly. (Having some issues updating my Knime to be able to read your workflow)

[bluena]

This answer works and is great but the cross join will cause performance issues when I’m handling a large dataset. Any alternatives?

[ipazin]

Hi there @bluena,

Cross Joiner is streamable so you can use streaming functionality.

Also there were similar topics to this one so you can check forum for more ideas/solutions. Here is one for example:

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

Br,
Ivan