This workflow demonstrates the usage of the DB DB Delete (Filter) node. The node removes all rows from the selected database table that match the entered filter criteria.
The workflow uses the Variable Expresssions node to create a date variable that is used in the DB Delete (Filter) node to delete all rows in the database table with a reportDate older than one year.
Workflow
DB Delete Filter Example
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.6.0
Legal
By using or downloading the workflow, you agree to our terms and conditions.