Icon

Exercise1

<p><strong>Chapter 4/Exercise 1</strong></p><p>This exercise shows how to apply some Date&amp;Time-specific manipulation nodes.</p>

Workflow: Chapter 4/Exercise 1

This exercise shows how to apply some Date&Time-specific manipulation nodes.

Date & Time manipulation

Reading data

Create time range

Writing data

Remove timestamps
Time Modifier
Filter data to time range: 30.03.2009 - 30.03.2011
Date&Time-based Row Filter
Group by month: number of cars soldand total revenue
GroupBy
Write to new filedatetime_ex2.csv
CSV Writer
Group by weekday:number of cars soldand total revenue
GroupBy
Remove rows withmissing date values
Missing Value
cars-85.csv
CSV Reader
Generate 170 datevalues between30.06.2008 and 30.06.2011
Date&Time Range Creator
Left outer joinon RowID toadd date column
Joiner
Extract year, month,day, and day of week
Date&Time Part Extractor

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2026-01-06
Last update: 2026-01-07
Created with KNIME version: v5.9.0
Tags: BooksKNIME Advanced LuckDate TimeDateTimeexercise

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

Try NodePit Runner!