Icon

UK Final Energy Consumption

UK Final Energy Consumption
Input data Cleaning Enrich data Output First analysis Total final energy consumption in the UK from 2005 to 2017 keep GWh sheetsconcatenate datasplit energy typeand sectorremove rowIDsremove empty columnsand totalsnew column namesmove to db formatenergy typesectorvaluesconvert values to numw/ missing valuesadd yearGWh per year per NUTS1 regionUK Eurostatgeographical hierarchyfrom NUTS1 to LAU2blend NUTSfilter LAU2 to go toLAU1 leveloutput Read Excel SheetNames (XLS) Row Filter Table Row ToVariable Loop Start Loop End Excel Reader (XLS) Cell Splitter Column Filter Insert ColumnHeader Column Filter File Reader Unpivoting Column Rename String To Number Math Formula GroupBy File Reader Joiner DuplicateRow Filter Column Resorter Tableau Writer(Hyper) Input data Cleaning Enrich data Output First analysis Total final energy consumption in the UK from 2005 to 2017 keep GWh sheetsconcatenate datasplit energy typeand sectorremove rowIDsremove empty columnsand totalsnew column namesmove to db formatenergy typesectorvaluesconvert values to numw/ missing valuesadd yearGWh per year per NUTS1 regionUK Eurostatgeographical hierarchyfrom NUTS1 to LAU2blend NUTSfilter LAU2 to go toLAU1 leveloutput Read Excel SheetNames (XLS) Row Filter Table Row ToVariable Loop Start Loop End Excel Reader (XLS) Cell Splitter Column Filter Insert ColumnHeader Column Filter File Reader Unpivoting Column Rename String To Number Math Formula GroupBy File Reader Joiner DuplicateRow Filter Column Resorter Tableau Writer(Hyper)

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: MSE
Created at: 2020-08-21
On NodePit since: 2020-08-28
Last update: 2024-04-27
Created with KNIME version: v4.1.2
Tags: ExcelData PrepEnergyUKData Manipulation

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

Try NodePit Runner!