Filter out rows with filter criteria from a different csv with (Rule Based Row-Splitter (Dictionary)

[phil21oo]

Hello,

i have a database and want to filter out rows which contain some words that i have in a table (for example buy, cheap… and many more)

column

1. burger cheap
2. burger tasty
3. buy burger
4. burger new york

filter out 1 and 3

Now my question is how can i implement this filter criteria to a (Rule Based Row-Splitter (Dictionary)? I know it is possible with loops but sb. said it is easy with the (Rule Based Row-Splitter (Dictionary)

Thx for your time

[gonhaddock]

Hello @phil21oo

You can implement it in different ways. My proposal is to test the linked workflow, as it’s based in regex recognition (that can somehow be customized), besides it high performs avoiding loops.

Data Wrangling _ Filtering with Wildcards (Regex Logical Indexing) – gonhaddock

Please, take a look into the following topic. You are not clarifying too much about your analysis context; like if your wildcard is unique search() or any but()… As you see, you can develop any logical rule afterwards.

Filter rows using list of words with wildcards

Hello @PLS_KN I couldn’t avoid to give this a try. It is based in a Logical Indexing methodology. It doesn’t use the Regex Extractor component (I cannot download it from my network today). [image] With the mentioned logical indexing matrix you can give this workflow some other LOGICAL uses like: when does a word happens when some other is present before… This is an example of the excluded words in your final filter: [image] I hope you find useful this workflow. BR

The workflow’s final filter has to be configured as ‘exclude TRUES’, to match your requested use case.

Let us know if further support is needed.

BR