DB Delete (Filter)

Deletes all data rows from the selected database table that match the specified filter conditions.
The output table contains two columns. The first column is the number of rows affected by the DELETE statement. A number greater than or equal to zero -- indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution. The second column shows a warning message, if any.
Within the dialog, an SQL WHERE clause is interactively created by adding and grouping conditions.

Options

Table to delete from

Click Select a table to select the table to delete from in the pop up dialog, or enter a valid Schema and Table name into the input fields.

Query view

This view 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.

Remove Group

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 delete all rows that have a missing value in the selected column use the IS 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.

Views

This node has no views

Workflows

• 23_DB_Delete_FilterKNIME Hub
• Extract DB data to SnowflakeKNIME Forum

Links

• No links available

Developers