Icon

Extract recent values from DB

This workflows shows how you can extract the values of the last 24 hours from a database table.

Connect to DBGet execution timeShift execution timeby 1 day SelecttableOnly data from the last dayNote: Date is controlled witha flow variableSQLite Connector Create Date&TimeRange Date&Time Shift Table Rowto Variable DB Table Selector DB Row Filter DB Reader Create and loaddata into DB Connect to DBGet execution timeShift execution timeby 1 day SelecttableOnly data from the last dayNote: Date is controlled witha flow variableSQLite Connector Create Date&TimeRange Date&Time Shift Table Rowto Variable DB Table Selector DB Row Filter DB Reader Create and loaddata into DB

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: kathrinmelcher
Created at: 2022-02-03
On NodePit since: 2022-02-04
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: databaseexecution time

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

Try NodePit Runner!