DB Row Filter

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

Preview: This preview shows the filter conditions and their hierarchy. Invalid conditions or groups are displayed in red.
Add Condition: Adds a new condition to the list. If a logical group is selected it will be added to that, if a condition is selected it will be added to its parent group.
Group: Combines the the selected conditions into a new logical group.
Ungroup: Deletes the selected logical group and move its child conditions to its parent.
Delete: Deletes the selected group or condition from the list.
Edit condition: Depending on the selected element in the preview list the selected group or condition can be edited.

If a group is selected its logical operator (AND,OR) can be changed.

If a condition is selected at least the column and the operator need to be specified. Further input fields are displayed depending on the selected operator e.g. the equal operator has one input field which allows to enter the value that should be used during comparison. In order to filter all rows that have a missing value in the selected column us the IS NOT NULL operator.
The icon at the end of the input fields fetches the unique values of the selected column and populates the drop-down box of the input field. To prevent memory problems this method is restricted to a fixed number of unique values. If the column contains more unique values a corresponding error message is displayed.

Input Ports

: DB Data to apply filtering.

Output Ports

: DB Data with matching rows.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

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.

Installation

To use this node in KNIME, install the extension KNIME Database from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.3.2.v202409010954

On NodePit since: 2024-07-09

Last update: 2024-11-20

KNIME versions: Since v3.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!