Icon

Assigment 1

Plotting

Get SCB data

Get SHMI data

SCB Power Production.knwf [Assignment 1 link]

Get suitable SHMI stations

CSV table uniformization for any type of parameter

Process different SHMI parameter fields

Prepare api data table

* Nodes containing date range

Normalisation

Power consuption x Temperature

Wind power generated x Wind speed

Water power generated x Precipitation

Precipitation x Energy generation type

Energy type plots

Wind speed x Energy generation type

hierarchical clustering

GET Request
JSON Path
Column Filter
Row Filter
Scatter Plot
Table Row to Variable Loop Start
Column Renamer
Ungroup
Joiner
Column Filter
Parallel Coordinates Plot
GroupBy
Row Filter
Hierarchical Clustering
String Manipulation
Pivot
Loop End
GroupBy
Table Row to Variable
Color Manager
String Manipulation
RowID
Scatter Plot
Table Row to Variable
Column Filter
Column Renamer
Column Renamer
Column Resorter
Row Filter
Rule-based Row Filter
String Manipulation (Variable)
processing keys and values
JSON Path
filter to contain only data from JSON path
Column Filter
extracting list data into multiple rows
Ungroup
converting keys to strings that are easy to read
String Manipulation
SCB data in .json format
POST Request
CASE Switch End
norm_avg
Math Formula
Date range filter
Row Filter
norm
Math Formula
Column Renamer
Row Filter
String to Date&Time
Line Plot
Column Name Replacer
Column Resorter
inverted norm
Math Formula
inverted norm_avg
Math Formula
Column Name Replacer
Column Name Replacer
String to Date&Time
Stations metadata
Table Creator
Column Name Replacer
Column Renamer
Parameters metadata
Table Creator
Column Name Replacer
String to Date&Time
Color Manager
String to Date&Time
Column Filter
Column Filter
Row Filter
Constant Value Column Appender
Color Manager
Column Renamer
Row Filter
Line Plot
String to Path
Column Renamer
Line Plot
Column Filter
Color Manager
Adding city and parameter name
Constant Value Column Appender
Keeping numerical statistics
GroupBy
normalising value key to "Value"
Column Name Replacer
Math Formula
parameter type switch
CASE Switch Start
Loop End
Math Formula
Keep only needed columns
Column Filter
String to Date&Time
Date&Time Part Extractor
Date&Time Part Extractor
Variable Creator
Row to Column Names
Column Renamer
grouping by year and month
GroupBy
Date&Time Part Extractor
splitting date to 2 columns
Cell Splitter
Column Renamer
Joiner
Color Manager
Row Filter
minMax shmi
GroupBy
shmi join
Joiner
Scatter Plot
Cross Joiner
Column Filter
minMax scb
GroupBy
GroupBy
Joiner
Column Renamer
Bar Chart
Color Manager
String Manipulation
norm
Math Formula
Pie Chart
collect and preprocess data from API
Table Row to Variable Loop Start
Row Filter
Row Filter
Color Manager
CSV Reader

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: andy
Created at: 2025-11-10
On NodePit since: 2025-11-11
Last update: 2025-12-02
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!