This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementDB Row FilterThis node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.
This node allows rows to be filtered from the input database table while the SQL result will only contain the remaining rows. Within the dialog, an SQL WHERE clause is interactively created by selecting a column, an operator, and a filter value.
Options
Popular Predecessors
Database Row Filter10 %Database Joiner6 %Database Sorter6 %Database Column Filter6 %Database GroupBy5 %Database Query4 %Table Row to Variable4 %- Java Edit Variable3 %
PostgreSQL Connector3 %- Inject Variables (Database)2 %
Database Table Selector2 %- Single Selection (legacy)2 %
- Date&Time Input (legacy)2 %
SQL Inject2 %- Value Selection (legacy)2 %
Database Pivot2 %Amazon Athena Connector2 %Database Table Connector1 %Database Column Rename1 %- Math Formula (Variable)1 %
Database Numeric-Binner1 %Database Connector1 %Database Table Creator1 %Database Connection Table Reader1 %CASE Switch Model (Start)< 1 %Microsoft SQL Server Connector< 1 %- String to Date&Time< 1 %
- Extract Variables (Database)< 1 %
Database Reader< 1 %Database Auto-Binner< 1 %- String Manipulation (Variable)< 1 %
- Java Edit Variable (simple)< 1 %
- Extract Variables (Data)< 1 %
- Rule Engine Variable< 1 %
Merge Variables< 1 %Hive Connector< 1 %Date Input (legacy)< 1 %Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Database SQL Executor< 1 %Database Sampling< 1 %Hive Loader (legacy)< 1 %MySQL Connector< 1 %SQLite Connector< 1 %- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Database Select Table (Interactive) (Legacy)< 1 %
Database End IF< 1 %Table Row to Variable< 1 %Variable to Table Row< 1 %Database Apply-Binner< 1 %Database Drop Table< 1 %Counting Loop Start< 1 %String To Number< 1 %- GroupBy< 1 %
CASE Switch Model (End)< 1 %- Interactive Table (legacy)< 1 %
Impala Connector< 1 %Vertica Connector< 1 %- DB GroupBy< 1 %
- Date&Time Configuration< 1 %
- Text Output (legacy)< 1 %
- Double Input (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- String Widget< 1 %
- Python Edit Variable (legacy)< 1 %
Date (String) Input (legacy)< 1 %- Date&Time to legacy Date&Time< 1 %
- Table Row to Variable< 1 %
- Table Row to Variable Loop Start< 1 %
- DB Sorter< 1 %
Views
- This node has no views
Workflows
01_Big_Data_Preprocessing_ExampleKNIME Hub- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- 01_Bioactivity_Prediction_Load_Pull_DataKNIME Hub
- Show all 14 workflows
Links
- No links available
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.