The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Database Row Filter

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.

Dialog Options

Column
Contains the columns available in the input table.
Operator
With the WHERE clause, the following operators can be used: =, <>, !=, >, <, >=, <=, BETWEEN, LIKE, IN
Value
Enter the specific value to filter on. Quotes ('') need to be added when filtering string columns. A "%" sign can be used to define wildcard pattern.

Ports

Input Ports
0 Table in database to apply row filter
Output Ports
0 Table in the database with filtered rows
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.