Icon

Data Wrangling _​ Filtering with Wildcards (Regex Logical Indexing)

Data Wrangling _ Filtering with Wildcards (Regex Logical Indexing)

Data Wrangling _ Filtering with Wildcards (Regex Logical Indexing)

Workflow created for the KNIME forum ... https://forum.knime.com/t/filter-rows-using-list-of-words-with-wildcards/42442

Data Wrangling _ Filtering with Wildcards (Regex Logical Indexing) Filtered Results Logical IndexingMatrix DescriptionstextsWildcards to be filteredall conbinationsdescriptions vs wildcardsregex match approachto any position in Text(no case sensitive)pivoting resultsand grouping bydescription Restore RowIDwith original orderConcatenate Automatic Column Regex Selectionregex match FILTERfind TTRUE in Logical Indexing Matrix's ConcatenateExclude FILTER == TrueROWINDEXSort by -ROWINDEX- Table Creator Table Creator Cross Joiner String Manipulation Pivoting RowID Column Aggregator String Manipulation Row Filter Math Formula Sorter Data Wrangling _ Filtering with Wildcards (Regex Logical Indexing) Filtered Results Logical IndexingMatrix DescriptionstextsWildcards to be filteredall conbinationsdescriptions vs wildcardsregex match approachto any position in Text(no case sensitive)pivoting resultsand grouping bydescription Restore RowIDwith original orderConcatenate Automatic Column Regex Selectionregex match FILTERfind TTRUE in Logical Indexing Matrix's ConcatenateExclude FILTER == TrueROWINDEXSort by -ROWINDEX- Table Creator Table Creator Cross Joiner String Manipulation Pivoting RowID Column Aggregator String Manipulation Row Filter Math Formula Sorter

Nodes

Extensions

Links