This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
This 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 Filter15 %Database Column Filter11 %Database GroupBy11 %Database Joiner8 %Database Sorter5 %Database Query3 %Table Row to Variable3 %- Java Edit Variable2 %
PostgreSQL Connector2 %- Inject Variables (Database)2 %
- Single Selection (legacy)2 %
- Date&Time Input (legacy)2 %
SQL Inject2 %- Value Selection (legacy)2 %
Database Pivot1 %Amazon Athena Connector1 %Database Table Connector1 %Database Column Rename1 %Database Table Selector1 %- Math Formula (Variable)1 %
Database Numeric-Binner< 1 %Database Connector< 1 %Database Table Creator< 1 %Database Connection Table Reader< 1 %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_Bioactivity_Prediction_Load_Pull_DataKNIME Hub
- 01_Guided_AnalyticsKNIME Hub
- Show all 13 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.