Loading …
NodePit
  • Products
  • Nodes
  • Workflows
  • About
  • KNIME 5.12
    KNIME 55.12LTS5.115.105.95.8LTS5.75.65.5LTS5.45.35.25.15.0
    KNIME 44.74.64.54.44.34.24.14.0
    KNIME 33.73.6
    In Development5.13Nightly
  • Log InSign Up
  1. HomeHome
  2. WorkflowsWorkflows
  3. KNIME HubKNIME Hub
  4. UsersUsers
  5. maaritmaarit
  6. PublicPublic
  7. ArticlesArticles
  8. Spreadsheet User's Guide To Data MasterySpreadsheet User's Guide To Data Mastery
  9. Access, preprocess and monitor electricity consumption dataAccess, preprocess and monitor electricity consumption data
Icon

Access, preprocess and monitor electricity consumption data

There has been no title set for this workflow's metadata.

This workflow demonstrates how to perform common spreadsheet user's tasks in KNIME, such as
- Data blending,
- Data cleaning,
- Data aggregation, and
- Data visualization.

Nodes

  • String Manipulation (Variable)13 ×
  • String Configuration6 ×
  • Component Input5 ×
  • Component Output5 ×
  • Rule Engine Variable5 ×
  • Merge Variables4 ×
  • CASE Switch Variable (End)3 ×
  • CASE Switch Variable (Start)3 ×
  • CSS Editor2 ×
  • Column Filter2 ×
  • Column Renamer2 ×
  • Date&Time Configuration2 ×
  • Integer Configuration2 ×
  • Line Plot2 ×
  • Math Formula (Variable)2 ×
  • Modify Time Zone2 ×
  • Single Selection Configuration2 ×
  • Table Row to Variable2 ×
  • Breakpoint1 ×
  • CASE Switch Data (End)1 ×
  • Color Manager1 ×
  • Column Auto Type Cast1 ×
  • Column Rename1 ×
  • Concatenate1 ×
  • Empty Table Switch1 ×
  • Excel Reader1 ×
  • Date&Time Part Extractor1 ×
  • Extract Variables (Data)1 ×
  • GET Request1 ×
  • Generic JavaScript View1 ×
  • Inject Variables (Data)1 ×
  • JSON Path1 ×
  • Lag Column1 ×
  • Modify Time1 ×
  • Pivoting1 ×
  • Row Aggregator1 ×
  • Row Filter1 ×
  • Scatter Plot1 ×
  • Sorter1 ×
  • String to Date&Time1 ×
  • Table Creator1 ×
  • Ungroup1 ×
  • Variable to Table Row1 ×

Extensions

  • No modules found

Links

  • The spreadsheet user's guide to data mastery
    www.knime.com/blog/spreadsheet-users-guide-to-data-mastery
  • Electricity Consumption in Finland provided by Fingrid
    data.fingrid.fi/en/dataset/electricity-consumption-in-finland

Download

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

Download Workflow
Created by: maaritwidmann
Created at: 2023-11-09
On NodePit since: 2023-12-12
Last update: 2026-07-13
Created with KNIME version: v5.2.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!
IntroNodesExtensionsLinks

NodePit is the world’s first and most comprehensive search engine that allows you to easily search, find and install KNIME nodes and workflows. Explore the KNIME community’s variety.

About
Impressum / Imprint
Datenschutzerklärung / Privacy Policy

Thank you to the following supporters — without them, NodePit would not be possible!

Legal info: The KNIME® trademark is registered in the United States and Germany by the KNIME GmbH. NodePit is not affiliated with KNIME®.