Icon

1-Prepare Data reduced reset

This workflow reads Ireland's electricity data, converts the dates from the proprietary format into datetime values, and groups kW values by: - day - hour - intra-day times - month - year - week It also aggregates average and % values for the k-Means procedure Node 50convert proprietary date formatinto datetime valueskW usage by meter IDby day, month, week, yearThe top port also offers:average kW usage daily, monthly, weekly, yearlyby meter IDkW usage by meter IDby hour and intra-day timesThe top port also offers:average kW usage hourly, for each intra-day timeby meter IDintra-day andintra-week kW % usageby meter IDRead 6 files for a total of 176 Mio RowsNode 99Node 100Joiner String to datetime Daily, Monthly,Yearly, Weekly Hourly, Intra-day % values Read all Data Write to server Write to CSV This workflow reads Ireland's electricity data, converts the dates from the proprietary format into datetime values, and groups kW values by: - day - hour - intra-day times - month - year - week It also aggregates average and % values for the k-Means procedure Node 50convert proprietary date formatinto datetime valueskW usage by meter IDby day, month, week, yearThe top port also offers:average kW usage daily, monthly, weekly, yearlyby meter IDkW usage by meter IDby hour and intra-day timesThe top port also offers:average kW usage hourly, for each intra-day timeby meter IDintra-day andintra-week kW % usageby meter IDRead 6 files for a total of 176 Mio RowsNode 99Node 100Joiner String to datetime Daily, Monthly,Yearly, Weekly Hourly, Intra-day % values Read all Data Write to server Write to CSV

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2022-02-06
Last update: 2024-12-22
Created with KNIME version: v4.1.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!