P2.2.1
Solution to the Exercise 1: Loading and Exploring Data
This workflow accesses, preprocesses, and visualizes time series (energy consumption) data by
- converting time values from String to Date&Time
- aligning the time series by linear interpolation where gaps
- showing the hourly, daily, and monthly total values in a line plot
URL: String to Date&Time Node https://youtu.be/uNgaEGzetkU
URL: Slides on the KNIME Website https://www.knime.com/form/material-download-registration
Nodes
- Column Rename (Regex)4 ×
- Create Date&Time Range4 ×
- End IF4 ×
- Rule Engine Variable4 ×
Table Row to Variable4 ×- CASE Switch Variable (Start)2 ×
- CSV Reader2 ×
- Column Filter2 ×
- Java Edit Variable2 ×
- Joiner2 ×
- Merge Variables2 ×
- Row Filter2 ×
- Sorter2 ×
- Boolean Configuration1 ×
- Column Selection Configuration1 ×
- Domain Calculator1 ×
- Extract Table Dimension1 ×
- Extract Table Spec1 ×
- IF Switch1 ×
- Image Writer (Port)1 ×
- Line Plot (JavaScript)1 ×
- Missing Value1 ×
- RowID1 ×
- Single Selection Configuration1 ×
- String to Date&Time1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME JavaScript Views
- FeatureKNIME Javasnippet
- FeatureKNIME Quick Forms
Links
- No links available