This node allows rows to be filtered from the input DB Data table so that the resulting DB Data table
will only contain the rows that match the specified filter conditions.
Within the dialog, an SQL WHERE clause is interactively created by adding and grouping conditions.
Options
Popular Successors
- DB Reader31 %
- DB GroupBy16 %
- DB Joiner15 %
- DB Row Filter11 %
- DB Query7 %
- DB Column Filter6 %
- DB Sorter2 %
- DB Pivot1 %
- DB Concatenate1 %
- DB Connection Table Writer< 1 %
- DB Column Rename< 1 %
- DB Query Extractor< 1 %
- DB Row Sampling< 1 %
- Parameterized DB Query Reader< 1 %
- CASE Switch End< 1 %
- CSV Writer< 1 %
- Column Filter< 1 %
- Hive to Spark< 1 %
- DB Type Mapper< 1 %
- DB Table Selector< 1 %
- Variable Loop End< 1 %
- DB Looping< 1 %
- DB Data Spec Extractor< 1 %
- DB Numeric-Binner< 1 %
- DB Insert Column Header< 1 %
- Joiner< 1 %
- DB Connection Extractor< 1 %
- DB Partitioning< 1 %
- Math Formula< 1 %
- DB Extract Table Dimension< 1 %
Database Connection Table Reader< 1 %Row Filter (deprecated)< 1 %- GroupBy< 1 %
Joiner< 1 %- CASE Switch Start< 1 %
- DB Connection Closer< 1 %
- DB Query Reader< 1 %
- DB Apply-Binner< 1 %
- DB Column Rename (Regex)< 1 %
- DB Table Creator< 1 %
- Snowflake H2O MOJO Predictor (Regression)< 1 %
- Date&Time to String< 1 %
- Active Branch Inverter< 1 %
- Reference Row Filter< 1 %
Merge Variables< 1 %Excel Writer (XLS)< 1 %- Try (Variable Ports)< 1 %
- Variable to Table Column< 1 %
- Variable to Table Row< 1 %
CSV Writer< 1 %Database Reader< 1 %- Table Row to Variable Loop Start< 1 %
- Decision Tree Learner< 1 %
- Numeric Scorer< 1 %
- Association Rule Learner< 1 %
Column Appender< 1 %- String Manipulation (Variable)< 1 %
- Rule Engine< 1 %
CASE Switch Model (End)< 1 %- Color Manager< 1 %
- DB to Spark< 1 %
- DB Writer< 1 %
- DB Auto-Binner< 1 %
- DB Query Injector< 1 %
- Variable Expressions< 1 %
Excel Writer (XLS)< 1 %- Excel Writer< 1 %
- Scatter Plot (JavaScript)< 1 %
- Auto Crop< 1 %
- Date&Time Difference< 1 %
Views
- This node has no views
Workflows
00_Getting_started_with_SnowflakeKNIME Hub- 01 Data and Time and DatabasesKNIME Hub
- 01 Date and Time and DatabasesKNIME Hub
- 01 Date and Time and DatabasesKNIME Hub
- 01 Date and Time and DatabasesKNIME Hub
- Show all 491 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.