Disclaimer: This node will be deprecated in a future version. Please consider using the standard (non-Labs) Row Filter node, which supports multiple conditions starting from KNIME Analytics Platform version 5.3.
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 Successors
- GroupBy19 %
- Joiner7 %
- Column Filter6 %
- Row Filter (Labs)6 %
Row Filter (deprecated)4 %- Excel Writer4 %
- Column Expressions3 %
- Concatenate2 %
- Reference Row Filter1 %
- Duplicate Row Filter1 %
- Sorter1 %
- Row Splitter (Labs)1 %
- Column Resorter1 %
- Pivot1 %
- Rule Engine< 1 %
- Math Formula (Multi Column)< 1 %
- CSV Writer< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Rule-based Row Filter< 1 %
- Constant Value Column< 1 %
- String Manipulation< 1 %
- Math Formula< 1 %
- Column Aggregator< 1 %
Column Rename< 1 %- Table Transposer< 1 %
- Table Row to Variable Loop Start< 1 %
- Chunk Loop Start< 1 %
Row Splitter (deprecated)< 1 %- Ungroup< 1 %
- String to Date&Time< 1 %
- Column Name Extractor< 1 %
- Domain Calculator< 1 %
- Files/Folders Meta Info< 1 %
Regex Extractor< 1 %Table Row To Variable Loop Start< 1 %- Decision Tree Learner< 1 %
- Cross Joiner< 1 %
- DB Merge< 1 %
- Group Loop Start< 1 %
- Linear Regression Learner< 1 %
- Missing Value< 1 %
- Numeric Outliers< 1 %
- Line Plot (JavaScript)< 1 %
- JSON Path< 1 %
- Python View (legacy)< 1 %
- Loop End< 1 %
- RowID< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Scatter Plot (legacy)< 1 %
- Modify Time Zone< 1 %
- Try (Data Ports)< 1 %
Loop End< 1 %- Cell Splitter< 1 %
- Lag Column< 1 %
- Timer Info< 1 %
- Python Script (legacy)< 1 %
- XPath< 1 %
Table Row to Variable< 1 %- Column Rename (Regex)< 1 %
- String Replacer< 1 %
- CASE Switch End< 1 %
- SDF Writer< 1 %
- Parallel Chunk Start< 1 %
- DB Writer< 1 %
- Table to JSON< 1 %
Python Script (1⇒1)< 1 %- R Snippet< 1 %
- Date&Time-based Row Filter< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %- Auto-Binner< 1 %
Cell Replacer< 1 %- Constant Value Column Filter< 1 %
- IF Switch< 1 %
Parquet Writer< 1 %- DB Insert< 1 %
- Similarity Search< 1 %
- Scatter Plot (Plotly)< 1 %
- OSM Map View< 1 %
Excel Writer (XLS)< 1 %- Tableau Writer< 1 %
- Delete Files/Folders (Table)< 1 %
- Path to String< 1 %
- Container Output (Table)< 1 %
- Regex Extractor< 1 %
- String to URI< 1 %
- Extract Variables (Data)< 1 %
- Loop End (Column Append)< 1 %
- Counting Loop Start< 1 %
Recursive Loop Start (2 ports)< 1 %- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Column Renamer (Dictionary)< 1 %
- Nominal Value Row Filter< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- Number Rounder< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Unpivot< 1 %
- Independent groups t-test< 1 %
- End IF< 1 %
- Cache< 1 %
- Extract Table Dimension< 1 %
- Color Manager< 1 %
- Table View< 1 %
- Parquet Writer< 1 %
- Line Plot (Plotly)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Excel Cell Updater< 1 %
- String to Path< 1 %
- Value Filter (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Rowset Filter< 1 %
- R View (Table)< 1 %
- Date&Time Part Extractor< 1 %
- Modify Time< 1 %
- Duplicate Filter< 1 %
- 2D/3D Scatterplot< 1 %
- Table Column to Variable< 1 %
- Table Row to Variable< 1 %
Database Table Creator< 1 %- Table Writer< 1 %
- Java Snippet< 1 %
- Recursive Loop End< 1 %
- X-Partitioner< 1 %
- k-Means< 1 %
- Numeric Scorer< 1 %
- Numeric Binner< 1 %
- Column Renamer< 1 %
- Column Appender< 1 %
- Column Merger< 1 %
- Column to Grid< 1 %
- Linear Correlation< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Partitioning< 1 %
- Column Filter (PMML)< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Row Aggregator< 1 %
- Row Sampling< 1 %
- Top k Row Filter< 1 %
- Value Lookup< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Data Explorer< 1 %
- Statistics< 1 %
- Empty Table Switch< 1 %
- Crosstab< 1 %
- Interactive Histogram (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Line Plot< 1 %
- Molecule Type Cast< 1 %
- DB Update< 1 %
- DB Table Creator< 1 %
- Strings to Document< 1 %
- Term to String< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- String to JSON< 1 %
- JSON to Table< 1 %
- Add Table to R< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Moving Aggregator< 1 %
- RDKit Two Component Reaction< 1 %
- Regression Predictor< 1 %
- Association Rule Learner< 1 %
- Filter Apply< 1 %
- Numeric Distances< 1 %
- String Matcher< 1 %
- Column Filter Configuration< 1 %
- Table to Event Log< 1 %
- Principal Moment of Intertia (PMI)-Derived Properties< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %- Add Empty Rows< 1 %
Column Appender< 1 %- Table Validator< 1 %
- Filter Apply Row Splitter< 1 %
- HiLite Row Splitter< 1 %
- Number to String (PMML)< 1 %
- Table Difference Finder< 1 %
- Ruleset Editor< 1 %
- Conditional Box Plot (legacy)< 1 %
- Box Plot (legacy)< 1 %
DB Table Creator< 1 %- Association Rule Learner (Borgelt)< 1 %
Excel Sheet Appender (XLS)< 1 %- Radar Plot Appender< 1 %
- Path to URI< 1 %
- Nominal Row Filter Configuration< 1 %
- Object Inserter< 1 %
- Table to R< 1 %
Extract Date&Time Fields< 1 %- Date&Time Shift< 1 %
- Geo Distances< 1 %
- SDF Writer< 1 %
- Normalize Plates (Z-Score)< 1 %
- Create Collection Column< 1 %
- URL to File Path< 1 %
- Image Writer (Table)< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Generic Loop Start< 1 %- Decision Tree Predictor< 1 %
- Random Forest Learner (Regression)< 1 %
- Case Converter< 1 %
- Column Auto Type Cast< 1 %
- Many to One< 1 %
- Interactive HiLite Collector< 1 %
CASE Switch Data (End)< 1 %- 3D Scatter Plot (Plotly)< 1 %
- Table to H2O< 1 %
Send to Tableau Server (TDE)< 1 %Transfer Files< 1 %- Value Filter Definition (legacy)< 1 %
- Column Filter Widget< 1 %
- Date&Time to legacy Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Moving Average< 1 %
- TIBCO Spotfire File Writer< 1 %
- Normalize Plates (POC)< 1 %
- Spell Checker (simple)< 1 %
- Strings to Binary Objects< 1 %
- Variable to Table Column< 1 %
CSV Writer< 1 %Table Writer< 1 %- Column List Loop Start< 1 %
- Generic Loop Start< 1 %
- Naive Bayes Learner< 1 %
- PNN Predictor< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- K Nearest Neighbor< 1 %
- OPTICS Cluster Assigner< 1 %
- Logistic Regression Learner< 1 %
- Scorer< 1 %
Scorer< 1 %- SMOTE< 1 %
- SOTA Predictor< 1 %
- SVM Learner< 1 %
- PCA Apply< 1 %
- PCA Compute< 1 %
- PCA< 1 %
- Gradient Boosted Trees Learner< 1 %
- Tree Ensemble Learner< 1 %
- Category to Number< 1 %
- String to SVG< 1 %
- Reference Column Splitter< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- Rule Engine Variable< 1 %
- Rank Correlation< 1 %
- Extract Table Spec< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
Color Appender< 1 %- Shape Manager< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- Parameterized DB Query Reader< 1 %
- Counter Generation< 1 %
- Conditional Label Assigner< 1 %
- Java Distance< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- Violin Plot (Plotly)< 1 %
- PMML Predictor< 1 %
- Line Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- OSM Map to Image< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Send to Power BI< 1 %- Send to Power BI< 1 %
- Java Snippet (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Spark Line Appender< 1 %
Tableau Writer (Hyper)< 1 %- IDF< 1 %
- Dictionary Replacer< 1 %
- Stanford Lemmatizer< 1 %
- Document Viewer< 1 %
- Google Sheets Updater< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Value Selection Widget< 1 %
- Feature Inserter< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Webpage Retriever< 1 %
- Create Date&Time Range< 1 %
- Modify Date< 1 %
- Extract Time Window (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Table to HTML String< 1 %
- RDKit Molecule Catalog Filter< 1 %
- RDKit To Molecule< 1 %
RDKit Structure Normalizer< 1 %- Latitude/Longitude to Coordinate< 1 %
Click< 1 %
Views
- This node has no views
Workflows
00_xplan sf dbconv-insert via xport-AccountKNIME Hub
01_xplan sf dbconv-insert via csv-AddressKNIME Hub- 01_xplan sf dbconv-insert via xport-AddressKNIME Hub
02-EDA-tutorial-solutionKNIME Hub- 04_Advanced_Row_FiltersKNIME Hub
- Show all 136 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.