Icon

WD-DE TASK3

Customer Data
Excel Reader
Change Column Type:String to Date
String to Date&Time
Month, Quarter, Year
Date&Time Part Extractor
Select Customer Data Table
DB Table Selector
Group: Year, QuarterColumn: Store TypeAggregation: Sum of Prices
DB Pivot
Connect to Database
H2 Connector
Write Data to Database
DB Writer
Create Column Combination:"Year/Quarter"
Expression
Quarterly Total Salesby Store Types
Stacked Area Chart
Sort by Year then Quarter
DB Sorter
Read as DB Table
DB Reader
Store with Total Sale >= 6000
DB Row Filter
Change Column Type:String to Date
String to Date&Time
Filter Left Tablefrom Right Table
DB Joiner
Group: StoreIDAggregation: Sum(Price)
DB GroupBy
Group: Year, QuarterColumn: Store TypeAggregation: Sum of Prices
Pivot
Customer Data
Excel Reader
Create Column Combination:"Year/Quarter"
Expression
Month, Quarter, Year
Date&Time Part Extractor
Read as DB Table
DB Reader
Orders after Jan 1, 2019
Date&Time-based Row Filter
Group: MonthColumn: YearAggregation: Sum of Prices
Pivot
Line Plot
By Column "Year/Quarter"
Sorter
Quarterly Total Salesby Store Types
Stacked Area Chart

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: Lenovo
Created at: 2025-12-20
On NodePit since: 2026-05-05
Last update: 2026-05-05
Created with KNIME version: v5.8.2

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

Try NodePit Runner!