Icon

EconomicDataImportPrep

read excel filefilter dates(as per orginal)add hoursroll out hours(creates 24 rows per date)group bydateadd counterstarting 0for hours(0 to 23)end loopshift timeby hour using counterchnge date to stringconvert todatetimeadd 00:00:00to stringremoveunrequired fieldsExcel Reader Date&Time-basedRow Filter Math Formula One Row to Many Group Loop Start Counter Generation Loop End Date&Time Shift Date&Time to String String to Date&Time String Manipulation Column Filter read excel filefilter dates(as per orginal)add hoursroll out hours(creates 24 rows per date)group bydateadd counterstarting 0for hours(0 to 23)end loopshift timeby hour using counterchnge date to stringconvert todatetimeadd 00:00:00to stringremoveunrequired fieldsExcel Reader Date&Time-basedRow Filter Math Formula One Row to Many Group Loop Start Counter Generation Loop End Date&Time Shift Date&Time to String String to Date&Time String Manipulation Column Filter

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: will
Created at: 2021-03-10
On NodePit since: 2022-02-06
Last update: 2024-04-27
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!