Icon

KNIME_​project1

Fetch and structure Energy Production data from SCB - Production Method - Date - Energy produced Each pipline row Fetches, Extracts and Preprocess the data for one given parameter, for all weather stationsEach pipeline may need to be customized for its specific parameter data Extract dataType,date of recording &energy amountRemove raw dataSeparate data points to individual rowsClean up the dataTypesFetch Energy Production data from SCBNode 208Node 209Node 251Node 253Node 254Node 255Node 256Node 257Node 258Node 259Node 260Node 261Node 262Node 263Node 264Node 265Node 266Node 267Node 268Node 269Node 270Node 271Node 272Node 273Node 274Node 275Node 276Node 277Node 278Node 279Node 280Node 281Node 282Node 283Node 284Node 285Node 286Node 287Node 288Node 289Node 290Node 291Node 292Total Production Per MethodNode 294Total Production Per MethodNode 296Monthly ProductionPer MethodNode 298Air TemperatureURI for all parameters and weather stationsAll desiredparameters and weather stationsAggregatemonthlyRemove Duplicated columnsMean Aggregate ValuesNode 323Node 324Node 325Node 326Node 327Node 328Node 329Node 330Node 331Node 332Node 333Node 334Node 335Node 336Node 337Node 338Node 339Node 340Node 341Node 342Node 343Node 344Node 345Node 346Node 347Node 348Node 349Node 350Node 351Node 352Node 353Node 354Node 355Node 356Node 357Node 358Node 359Node 360Node 361Node 362Node 363Node 364Node 365Node 366Node 367AggregateRegional dataNode 369Node 398Node 399Node 400Node 401Mean dataMinimum DataMaximum DataMin Aggregate ValuesMax Aggregate ValuesNode 408Maximum DataNode 410Node 414Node 415Node 416Node 417Node 418AggregatemonthlyAir TemperatureNode 421Node 422Node 423Node 424AggregatemonthlyAir TemperatureNode 427Node 428Node 429Node 430AggregatemonthlyAir TemperatureNode 433Node 434Node 435Node 436AggregatemonthlyAir TemperatureNode 439Node 440Node 441Node 442AggregatemonthlyAir TemperatureNode 445Node 446Node 447Node 448Node 449AggregatemonthlyAir TemperatureNode 452Node 453All desiredparameters and weather stationsURI for all parameters and weather stationsNode 461Node 463Node 464Node 467Node 468Node 469Node 470Node 471Node 472Node 473Node 474Node 475Node 476Node 477Node 479Node 480Node 481URI for all parameters and weather stationsAir TemperatureNode 484All desiredparameters and weather stationsNode 486Node 487Node 488JSON Path Column Filter Ungroup String Manipulation POST Request Joiner Joiner Joiner String to Date&Time Joiner String to Date&Time GET Request XPath String To Number XPath XPath String to Date&Time Column Filter String To Number Date&Time-basedRow Filter GET Request GET Request Column Filter Joiner Date&Time-basedRow Filter Date&Time-basedRow Filter String To Number Column Filter String to Date&Time Joiner String to Date&Time GET Request XPath String To Number XPath XPath String to Date&Time Column Filter String To Number Date&Time-basedRow Filter GET Request GET Request Column Filter Joiner Date&Time-basedRow Filter Date&Time-basedRow Filter String To Number Column Filter Bar Chart Color Manager Line Plot Pivoting Line Plot String Manipulation Row Filter String Manipulation Table Creator GroupBy Column Filter Line Plot Normalizer Joiner Row Filter XPath String To Number String to Date&Time Column Filter Joiner XPath GET Request GET Request XPath String To Number Date&Time-basedRow Filter Date&Time-basedRow Filter Date&Time-basedRow Filter String to Date&Time Column Filter GET Request String to Date&Time Joiner String To Number Column Filter XPath String To Number String to Date&Time Column Filter Joiner XPath GET Request GET Request XPath String To Number Date&Time-basedRow Filter Date&Time-basedRow Filter Date&Time-basedRow Filter String to Date&Time Column Filter GET Request String to Date&Time Joiner String To Number Column Filter Joiner Joiner GroupBy Row Filter Joiner Joiner Joiner Joiner Column Filter Column Filter Column Filter Line Plot Line Plot Line Plot Column Filter CSV Reader String to Path Date&Time-basedRow Filter Table Row ToVariable Loop Start Loop End Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Table Row ToVariable Loop Start CSV Reader GroupBy Row Filter Loop End Date&Time-basedRow Filter Table Creator String Manipulation JSON Reader Ungroup JSON Path k-Means Color Manager Scatter Matrix(local) Distance MatrixCalculate Hierarchical Clustering(DistMatrix) HierarchicalCluster Assigner Color Manager Scatter Matrix(local) Row Filter String to Path Ungroup OSM Map View JSON Path Table Rowto Variable String Manipulation Row Filter JSON Reader Table Creator Table Row ToVariable Loop Start String to Path(Variable) Loop End Fetch and structure Energy Production data from SCB - Production Method - Date - Energy produced Each pipline row Fetches, Extracts and Preprocess the data for one given parameter, for all weather stationsEach pipeline may need to be customized for its specific parameter data Extract dataType,date of recording &energy amountRemove raw dataSeparate data points to individual rowsClean up the dataTypesFetch Energy Production data from SCBNode 208Node 209Node 251Node 253Node 254Node 255Node 256Node 257Node 258Node 259Node 260Node 261Node 262Node 263Node 264Node 265Node 266Node 267Node 268Node 269Node 270Node 271Node 272Node 273Node 274Node 275Node 276Node 277Node 278Node 279Node 280Node 281Node 282Node 283Node 284Node 285Node 286Node 287Node 288Node 289Node 290Node 291Node 292Total Production Per MethodNode 294Total Production Per MethodNode 296Monthly ProductionPer MethodNode 298Air TemperatureURI for all parameters and weather stationsAll desiredparameters and weather stationsAggregatemonthlyRemove Duplicated columnsMean Aggregate ValuesNode 323Node 324Node 325Node 326Node 327Node 328Node 329Node 330Node 331Node 332Node 333Node 334Node 335Node 336Node 337Node 338Node 339Node 340Node 341Node 342Node 343Node 344Node 345Node 346Node 347Node 348Node 349Node 350Node 351Node 352Node 353Node 354Node 355Node 356Node 357Node 358Node 359Node 360Node 361Node 362Node 363Node 364Node 365Node 366Node 367AggregateRegional dataNode 369Node 398Node 399Node 400Node 401Mean dataMinimum DataMaximum DataMin Aggregate ValuesMax Aggregate ValuesNode 408Maximum DataNode 410Node 414Node 415Node 416Node 417Node 418AggregatemonthlyAir TemperatureNode 421Node 422Node 423Node 424AggregatemonthlyAir TemperatureNode 427Node 428Node 429Node 430AggregatemonthlyAir TemperatureNode 433Node 434Node 435Node 436AggregatemonthlyAir TemperatureNode 439Node 440Node 441Node 442AggregatemonthlyAir TemperatureNode 445Node 446Node 447Node 448Node 449AggregatemonthlyAir TemperatureNode 452Node 453All desiredparameters and weather stationsURI for all parameters and weather stationsNode 461Node 463Node 464Node 467Node 468Node 469Node 470Node 471Node 472Node 473Node 474Node 475Node 476Node 477Node 479Node 480Node 481URI for all parameters and weather stationsAir TemperatureNode 484All desiredparameters and weather stationsNode 486Node 487Node 488JSON Path Column Filter Ungroup String Manipulation POST Request Joiner Joiner Joiner String to Date&Time Joiner String to Date&Time GET Request XPath String To Number XPath XPath String to Date&Time Column Filter String To Number Date&Time-basedRow Filter GET Request GET Request Column Filter Joiner Date&Time-basedRow Filter Date&Time-basedRow Filter String To Number Column Filter String to Date&Time Joiner String to Date&Time GET Request XPath String To Number XPath XPath String to Date&Time Column Filter String To Number Date&Time-basedRow Filter GET Request GET Request Column Filter Joiner Date&Time-basedRow Filter Date&Time-basedRow Filter String To Number Column Filter Bar Chart Color Manager Line Plot Pivoting Line Plot String Manipulation Row Filter String Manipulation Table Creator GroupBy Column Filter Line Plot Normalizer Joiner Row Filter XPath String To Number String to Date&Time Column Filter Joiner XPath GET Request GET Request XPath String To Number Date&Time-basedRow Filter Date&Time-basedRow Filter Date&Time-basedRow Filter String to Date&Time Column Filter GET Request String to Date&Time Joiner String To Number Column Filter XPath String To Number String to Date&Time Column Filter Joiner XPath GET Request GET Request XPath String To Number Date&Time-basedRow Filter Date&Time-basedRow Filter Date&Time-basedRow Filter String to Date&Time Column Filter GET Request String to Date&Time Joiner String To Number Column Filter Joiner Joiner GroupBy Row Filter Joiner Joiner Joiner Joiner Column Filter Column Filter Column Filter Line Plot Line Plot Line Plot Column Filter CSV Reader String to Path Date&Time-basedRow Filter Table Row ToVariable Loop Start Loop End Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Date&Time-basedRow Filter GroupBy Row Filter Loop End Table Row ToVariable Loop Start CSV Reader Table Row ToVariable Loop Start CSV Reader GroupBy Row Filter Loop End Date&Time-basedRow Filter Table Creator String Manipulation JSON Reader Ungroup JSON Path k-Means Color Manager Scatter Matrix(local) Distance MatrixCalculate Hierarchical Clustering(DistMatrix) HierarchicalCluster Assigner Color Manager Scatter Matrix(local) Row Filter String to Path Ungroup OSM Map View JSON Path Table Rowto Variable String Manipulation Row Filter JSON Reader Table Creator Table Row ToVariable Loop Start String to Path(Variable) Loop End

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: Morning
Created at: 2021-11-06
On NodePit since: 2021-11-06
Last update: 2021-11-10
Created with KNIME version: v4.4.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!