Icon

03-01 - Date&Time

Session III: Date&Time Data Type

  1. Work with Date column in the output table of the Processed Customer Datametanode:

    • Convert string Date to Date&Time data type (String to Date&Time node)

    • Filter the data by date, starting on March 1, 2020 until the current date, by Date&Time-based Row Filter node.

    • Extract Month(number), Quarter and Year into new columns with Extract Date&Time Fields node.

    • Aggregate monthly total sale via Pivot node with Month(number) as the group and Year as the pivot

    • Plot monthly sales numbers in a line plot with Line Plot node, each line representing different years

Date&Time Difference
Date&Time Range Creator
Group: MonthPivot: YearAggregation: sum of Price
Pivot
Total sale duringthe course of ayear
Line Plot
Time Shifter
Date Shifter
Date Rounder
Time Zone Modifier
Time Rounder
Time Rounder
Create Table with Date/Time Columns
Table Creator
Math Formula
Month, Quarter & Year
Date&Time Part Extractor
Date&Time Range Creator
Joined data
Processed Customer Data
Moving Average
Selecting datastarting on March 1, 2020
Date&Time-based Row Filter
Expression
Line Plot
Select column Date
String to Date&Time
Create Table with Date/Time Columns
Table Creator
String to Duration
Date - Column as String
Excel Reader
Duration to String
Date&Time to String

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: andi_KNIME
Created at: 2025-11-12
On NodePit since: 2025-11-13
Last update: 2025-11-13
Created with KNIME version: v5.8.0

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

Try NodePit Runner!