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