Icon

20210816_​UploadDECTtoDB_​V3

Weekly files Daily files Delete png files Upload to DB List specifc filesExtractinformation from file namesCreatestring from pathRenamecolumnsfor readabilityForeach file...Foreach file...Readspecific rowsfrom file andrename columnsAddvariables to tableReplacestring by date variableCreate sum of rowsJoinonly one row... next fileSort by dateExtractdate specific informationAddconstant '+'for Ertrag/VerbrauchAddvariables to tableReplacestring by date variable... next fileExtractdate specific informationAddconstant '+'for Ertrag/VerbrauchSort by id & dateReadspecific rowsfrom file andrename columnsAdd negativ shift valuesfor date correctionCross joinall rowsShiftdate according to columns 'Shift'Calculatesum of rowsfor same dateConnect to DBWritedata to DBWritedata to DBRenamespecific columnsRenamespecific columnsSelectall png filesin download folder Deleteall selected filesMovefile to MessungVerbrauchExtractpath to tableCreate URI from pathExtractpath to tableCreateURI from pathMovefile to PVAnlageRoundall doubleRound all doubleNode 49 List Files/Folders Regex Split Path to String Column Rename Table Row ToVariable Loop Start Table Row ToVariable Loop Start CSV Reader Variable toTable Row String to Date&Time Math Formula(Multi Column) Joiner Loop End Sorter Extract Date&TimeFields ConstantValue Column Variable toTable Row String to Date&Time Loop End Extract Date&TimeFields ConstantValue Column Sorter CSV Reader Java Snippet(simple) Cross Joiner Date&Time Shift GroupBy SQLite Connector DB Writer DB Writer Column Rename Column Rename List Files/Folders Delete Files/Folders(Table) Copy/Move Files(legacy) Variable toTable Row Path to URI Variable toTable Row Path to URI Copy/Move Files(legacy) Round Double Round Double Rule-basedRow Splitter Weekly files Daily files Delete png files Upload to DB List specifc filesExtractinformation from file namesCreatestring from pathRenamecolumnsfor readabilityForeach file...Foreach file...Readspecific rowsfrom file andrename columnsAddvariables to tableReplacestring by date variableCreate sum of rowsJoinonly one row... next fileSort by dateExtractdate specific informationAddconstant '+'for Ertrag/VerbrauchAddvariables to tableReplacestring by date variable... next fileExtractdate specific informationAddconstant '+'for Ertrag/VerbrauchSort by id & dateReadspecific rowsfrom file andrename columnsAdd negativ shift valuesfor date correctionCross joinall rowsShiftdate according to columns 'Shift'Calculatesum of rowsfor same dateConnect to DBWritedata to DBWritedata to DBRenamespecific columnsRenamespecific columnsSelectall png filesin download folder Deleteall selected filesMovefile to MessungVerbrauchExtractpath to tableCreate URI from pathExtractpath to tableCreateURI from pathMovefile to PVAnlageRoundall doubleRound all doubleNode 49List Files/Folders Regex Split Path to String Column Rename Table Row ToVariable Loop Start Table Row ToVariable Loop Start CSV Reader Variable toTable Row String to Date&Time Math Formula(Multi Column) Joiner Loop End Sorter Extract Date&TimeFields ConstantValue Column Variable toTable Row String to Date&Time Loop End Extract Date&TimeFields ConstantValue Column Sorter CSV Reader Java Snippet(simple) Cross Joiner Date&Time Shift GroupBy SQLite Connector DB Writer DB Writer Column Rename Column Rename List Files/Folders Delete Files/Folders(Table) Copy/Move Files(legacy) Variable toTable Row Path to URI Variable toTable Row Path to URI Copy/Move Files(legacy) Round Double Round Double Rule-basedRow Splitter

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: Fred
Created at: 2021-08-16
On NodePit since: 2021-08-31
Last update: 2024-11-18
Created with KNIME version: v4.4.0

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

Try NodePit Runner!