Icon

Subnational_​Total_​Final_​Energy_​Consumption_​Statistic

Node 22005r GWhColumnHeadingRemoveTotal and Blank ColumnsUnpivotthe Energy, Sector andGWhSplit Energy and SectorRemoveUnnecessaryRowIDs, Energy+SectorsRenameMeaningless Column Namesto GWh, Energy_Typeand SectorsAdd Year2015RemoveTotal Region RowsNode 24Filter to includeonly GWhExcludePath ColumnNode 282005r GWhGoogleAuthentication Excel Reader Excel Reader Insert ColumnHeader Column Filter Unpivoting Cell Splitter Column Filter Column Rename ConstantValue Column Rule-basedRow Filter Read ExcelSheet Names Row Filter Column Filter Table Row ToVariable Loop Start Loop End Excel Reader Node 22005r GWhColumnHeadingRemoveTotal and Blank ColumnsUnpivotthe Energy, Sector andGWhSplit Energy and SectorRemoveUnnecessaryRowIDs, Energy+SectorsRenameMeaningless Column Namesto GWh, Energy_Typeand SectorsAdd Year2015RemoveTotal Region RowsNode 24Filter to includeonly GWhExcludePath ColumnNode 282005r GWhGoogleAuthentication Excel Reader Excel Reader Insert ColumnHeader Column Filter Unpivoting Cell Splitter Column Filter Column Rename ConstantValue Column Rule-basedRow Filter Read ExcelSheet Names Row Filter Column Filter Table Row ToVariable Loop Start Loop End Excel Reader

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: PhyoMinThant(MC)
Created at: 2021-05-08
On NodePit since: 2021-05-13
Last update: 2024-12-17
Created with KNIME version: v4.3.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!