0 ×

DB Row Filter

KNIME databases nodes version 0.9.0.v201807081650 by KNIME AG, Zurich, Switzerland

This node allows rows to be filtered from the input database table so that the SQL result will only contain the remaining rows.Within the dialog, an SQL WHERE clause is interactively created by adding and grouping conditions.

Options

Conditions
This list contains the conditions.
Add Condition
Add condition to the list. If a logical operator is selected it will be added to that, if a condition is selected it will be added to the parent logical operator.
Group
Create a new logical operator and put the selected condition below.
Ungroup
Delete the selected logical operator and put the conditions from it to the parent logical operator.
Delete
Delete the selected element from the list.

Input Ports

Icon
Table in database to apply filtering

Output Ports

Icon
Table in the database with filtered rows

Best Friends (Incoming)

Best Friends (Outgoing)

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.