This node allows to filter rows based on a query defined in the node dialog.
A query can contain conditions on multiple columns,
which can be grouped and combined with either the logical AND or logical OR operation.
The row filter also allows to apply conditions to the RowID as well as index based conditions.
The corresponding columns are called <RowID> and <RowINDEX> and are always the top most options when
opening the drop down for column selection. The <RowID> is treated as a string column, while the <RowINDEX> is considered
to be numerical starting at index 0.
Options
Buttons and views
Operators
Popular Predecessors
- Joiner9 %
- Row Filter (Labs)9 %
- GroupBy8 %
- Row Filter6 %
- Column Expressions5 %
- Column Filter5 %
- Excel Reader4 %
- Concatenate3 %
- CSV Reader3 %
- Duplicate Row Filter3 %
- Column Resorter2 %
- Sorter2 %
Column Rename2 %- String Manipulation2 %
- Rule Engine2 %
- Reference Row Filter2 %
- String to Number1 %
- Missing Value1 %
- Row Splitter1 %
- Date&Time Difference1 %
- Rule-based Row Filter1 %
- Math Formula1 %
- Rank1 %
- File Reader< 1 %
CSV Reader< 1 %- String to Date&Time< 1 %
- Table Manipulator< 1 %
- DB Query Reader< 1 %
- Date&Time-based Row Filter< 1 %
- Row Splitter (Labs)< 1 %
- Number to String< 1 %
- Table Creator< 1 %
- Extract Date&Time Fields< 1 %
- DB Reader< 1 %
- Crosstab< 1 %
- List Files/Folders< 1 %
Loop End< 1 %- Table View (JavaScript)< 1 %
- Pivot< 1 %
- Read Excel Sheet Names< 1 %
- Loop End< 1 %
- Constant Value Column< 1 %
- Value Counter< 1 %
- Unpivot< 1 %
- IF Switch< 1 %
- Timer Info< 1 %
- Parquet Reader< 1 %
- Domain Calculator< 1 %
- Table Reader< 1 %
- Group Loop Start< 1 %
Cell Replacer< 1 %- String Manipulation (Multi Column)< 1 %
- Date&Time to String< 1 %
- Table Row to Variable Loop Start< 1 %
- Rule-based Row Splitter< 1 %
Table Row to Variable< 1 %- Cross Joiner< 1 %
Extract Date&Time Fields< 1 %- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
- Column Renamer (Dictionary)< 1 %
- Filter Apply< 1 %
- Missing Value Column Filter< 1 %
Joiner< 1 %- Partitioning< 1 %
- Column Filter (PMML)< 1 %
- RowID< 1 %
- Math Formula (Multi Column)< 1 %
- RDKit Descriptor Calculation< 1 %
- Linear Correlation< 1 %
- Column Splitter< 1 %
- Nominal Row Filter Configuration< 1 %
Table Reader< 1 %- Java Snippet< 1 %
- Cell Splitter< 1 %
- Column Aggregator< 1 %
- Nominal Value Row Filter< 1 %
- String Replacer< 1 %
Excel Reader (XLS)< 1 %- Column Appender< 1 %
Parquet Reader< 1 %- Value Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- Column Renamer< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
- Column Merger< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Color Manager< 1 %
- Association Rule Learner< 1 %
- One to Many< 1 %
- Round Double< 1 %
- Rank Correlation< 1 %
- Math Formula (Variable)< 1 %
- Path to String< 1 %
- Column Filter Configuration< 1 %
- Scorer< 1 %
Variable to Table Column< 1 %- Chunk Loop Start< 1 %
- Case Converter< 1 %
- Column Auto Type Cast< 1 %
- Data Explorer< 1 %
- Nominal Row Filter Widget< 1 %
- Date&Time Shift< 1 %
- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader (Complex Format)< 1 %
- Line Reader< 1 %
- Column Combiner< 1 %
- Row Sampling< 1 %
- Numeric Outliers< 1 %
- SAS7BDAT Reader< 1 %
- Google Sheets Reader< 1 %
- Python Script (legacy)< 1 %
- Moving Aggregator< 1 %
Regex Extractor< 1 %- TIBCO Spotfire File Reader< 1 %
- URL to File Path< 1 %
File Reader< 1 %- Column Comparator< 1 %
- Double to Integer< 1 %
- Nominal Value Row Splitter< 1 %
- Statistics< 1 %
- Extract Table Dimension< 1 %
- Data Generator< 1 %
- Counter Generation< 1 %
- Java Snippet (simple)< 1 %
- String Configuration< 1 %
- Column Filter (legacy)< 1 %
- JSON Path< 1 %
- GET Request< 1 %
- Variable Loop End< 1 %
- Numeric Scorer< 1 %
- Column Rename (Regex)< 1 %
- Table Validator< 1 %
- DB Writer< 1 %
- Modify Time< 1 %
- Radar Plot Appender< 1 %
- Loop End (Column Append)< 1 %
- String Similarity< 1 %
- Recursive Loop Start< 1 %
Table Column to Variable< 1 %- Edit Nominal Domain< 1 %
- Similarity Search< 1 %
- String Matcher< 1 %
- Fixed Width File Reader< 1 %
Recursive Loop Start< 1 %- UNIX Timestamp to Date&Time< 1 %
- MarvinSketch< 1 %
- Try (Data Ports)< 1 %
Simple File Reader< 1 %Interval Loop Start< 1 %- Column List Loop Start< 1 %
- Constant Value Column Filter< 1 %
- Variable Expressions< 1 %
- JSON to Table< 1 %
- Webpage Retriever< 1 %
- Variable Creator< 1 %
- Recursive Loop End< 1 %
- DBSCAN< 1 %
- Random Forest Learner< 1 %
- Table Validator (Reference)< 1 %
- Denormalizer (PMML)< 1 %
- Double Configuration< 1 %
- Date&Time Input (legacy)< 1 %
- Value Selection Widget< 1 %
- Strings to Binary Objects< 1 %
Table Row To Variable Loop Start< 1 %Database Reader< 1 %- Reference Row Splitter< 1 %
ORC Reader< 1 %- StanfordNLP Relation Extractor< 1 %
- Value Selection (legacy)< 1 %
- Python Source (legacy)< 1 %
- SPARQL Query< 1 %
- Affinity Calculator (HYDE)< 1 %
IF Switch (Flow Variable Value)< 1 %- End IF< 1 %
Read Excel Sheet Names (XLS)< 1 %- Tika Parser< 1 %
- Tags to String< 1 %
- Google Analytics Query (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
PDB Connector< 1 %- Shapefile Polygon Reader< 1 %
- R Snippet (2:1)< 1 %
- Create Collection Column< 1 %
- Breakpoint< 1 %
- Inject Variables (Data)< 1 %
Database Connection Table Reader< 1 %Line Reader< 1 %List Files< 1 %- Feature Selection Filter< 1 %
- Feature Selection Loop End< 1 %
Counting Loop Start< 1 %Generic Loop Start< 1 %Recursive Loop Start (2 ports)< 1 %- Silhouette Coefficient< 1 %
- k-Means< 1 %
- Entropy Scorer< 1 %
- PCA< 1 %
- Numeric Binner< 1 %
- Create Bit Vector< 1 %
Column Appender< 1 %- Correlation Filter< 1 %
- Top k Row Filter< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Numeric Outliers (Apply)< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- SDF Reader< 1 %
- DB Delete (Table)< 1 %
- Empty Table Creator< 1 %
- k-Medoids< 1 %
- Index Query< 1 %
- MDF Reader< 1 %
- Java Snippet Row Filter< 1 %
- Punctuation Erasure< 1 %
- Term to String< 1 %
- Value Selection Configuration< 1 %
- Integer Input (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- List Box Widget< 1 %
- Multiple Selection Widget< 1 %
Container Input (Variable)< 1 %- DELETE Request< 1 %
- POST Request< 1 %
- Extract Duration Fields< 1 %
- Modify Date< 1 %
- String to Date/Time (legacy)< 1 %
XML Reader< 1 %- RDKit Molecule Catalog Filter< 1 %
- RDKit Optimize Geometry< 1 %
- Docking (FlexX)< 1 %
- Prime MM-GBSA< 1 %
- Unique Title Check< 1 %
- Correlation Matrix To Pairs< 1 %
- Multiport Loop End< 1 %
- Empty Collection to Missing< 1 %
- Split Collection Column< 1 %
- Image to Table< 1 %
- Extract System Properties< 1 %
- Cluster Assigner< 1 %
- PCA Compute< 1 %
- Random Forest Predictor< 1 %
- Add Empty Rows< 1 %
- Lag Column< 1 %
- Reference Column Filter< 1 %
- Normalizer< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- Regex Split< 1 %
- String Manipulation (Variable)< 1 %
- Table Difference Finder< 1 %
- Cronbach Alpha< 1 %
- Independent groups t-test< 1 %
CASE Switch Data (End)< 1 %Merge Variables< 1 %- Box Plot (legacy)< 1 %
Color Appender< 1 %- Shape Manager< 1 %
- DB Insert< 1 %
- Java Snippet Row Splitter< 1 %
- Frequency Filter< 1 %
- NGram Creator< 1 %
- PDF Parser< 1 %
- Bag Of Words Creator< 1 %
- Sentence Extractor< 1 %
- Strings to Document< 1 %
- List Box Configuration< 1 %
- File Chooser (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- String Widget< 1 %
- Container Input (Table)< 1 %
- XML to JSON< 1 %
- Salesforce Simple Query< 1 %
- Duration to Number< 1 %
- Create Date&Time Range< 1 %
- Moving Average< 1 %
- Twitter Users< 1 %
- XML Row Combiner< 1 %
- XPath< 1 %
- RDKit From Molecule< 1 %
- Neo4j Reader< 1 %
Views
- This node has no views
Workflows
02-EDA-tutorial-solutionKNIME Hub- 04_Advanced_Row_FiltersKNIME Hub
- 04_Advanced_Row_FiltersKNIME Hub
- 05-clustering-football-solutionKNIME Hub
- 08_List_Images_From_WikipediaKNIME Hub
- Show all 90 workflows
Links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.