Icon

02. Schedule - Exercise

<p><strong>Learning objective: </strong>In this exercise you will practice the scheduling of a workflow on KNIME Community Hub. Note that you need a Team plan subscription.</p><p><strong>Workflow description: </strong>Read the transactions from the database and filter the ones from the last hour. The component creates a report about the transactions and saves it in a pdf file. Scheduling this workflow to run once every hour, you will get a new pdf report with the latest transactions.</p><p><strong>You'll find the instructions to the exercises in the yellow annotations.</strong></p>
Filter transactions in the last hour

Filter the transactions from the last hour.


Read transactions from database

All the latest transactions of the stores are saved in the database.


Create a report with the latest transactions

The component does not filter data. So make sure to pass in input only the data of the latest hour.


Create a unique filename for the pdf report

In the form report_currenttime.pdf


Write report to file

By default the report is saved in the same space of this workflow.


Start here!

  1. Login to KNIME Community Hub

  2. Upload this workflow to one of your spaces*

  3. Create a version of the workflow

  4. Schedule the execution every hour

  5. Check the pdf report created once the workflow is executed

*You need a paid plan subscription on KNIME Hub

Schedule on KNIME Hub

Schedule this workflow on KNIME Hub to automatically generate a report every hour.

Note that you need a paid plan subscription to schedule workflows on KNIME Hub.

Transactions in thelast hour
Date&Time-based Row Filter
Table Row to Variable
Current Time
Date&Time Range Creator
Report Template Creator
Round to seconds
Time Rounder
Create report forthe last hour
Component
Minus 1h
Time Shifter
SQLite Connector
DB Table Selector
Write pdf report
Report PDF Writer
daily transactions
DB Reader
Create filenamevariable
Create File/Folder Variables
report_currenttime
Variable Expression
Path to String (Variable)

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: emiliosilvestri
Created at: 2024-08-16
On NodePit since: 2025-10-28
Last update: 2025-10-30
Created with KNIME version: v5.8.0
Tags: educationautomationschedulingKNIME Community HubTeams plan

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

Try NodePit Runner!