Using Knime Row Filter to Select 2 Text Values in a Column

I would like to use Knime Row Filter to filter data showing row where Column Country is “Germany” AND “USA”. How can i acheive this?

Seems i am only able to select 1 country. Any advice?

Hi @bluecar007,

Do you mean rows with country Germany or USA?

  • Under Pattern matching, select regular expression
  • Enter the following pattern:
Germany|USA

The pipe | acts as the logical OR, meaning it will include rows where the “Country” column is either “Germany” or “USA.”

Regards,
Yogesh

2 Likes

Hey @bluecar007,

while it is absolutely true what @yogesh_nawale suggest and the correct solution, if you have the possibility to upgrade your KNIME version to > 5.3, we have recreated the row filter to make exactly these use cases much easier.

Greetings,
Daniel

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.