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

[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