Icon

Using Date&Time Formats in KNIME

Exploring the Date&Time Nodes This workflow shows some operations with the Date&Time nodes in KNIMEAnalytics Platform. For more background information on the dataset see https://www.kaggle.com/rohitsahoo/sales-forecasting Read the data Convert String to Date&Time Superstore Sales DataString to Date:order dateship dateonly values for 2018days between order dateand ship datecreate date entry every 7 daysadd 5 days to ship datehow many ordersper monthkeep only entries fordates present in left tableCSV Reader String to Date&Time Date&Time-basedRow Filter Pivoting Date&TimeDifference Column Rename Create Date&TimeRange Date&Time Shift Column Rename AggregationGranularity Column Resorter Extract Date&TimeFields Joiner Exploring the Date&Time Nodes This workflow shows some operations with the Date&Time nodes in KNIMEAnalytics Platform. For more background information on the dataset see https://www.kaggle.com/rohitsahoo/sales-forecasting Read the data Convert String to Date&Time Superstore Sales DataString to Date:order dateship dateonly values for 2018days between order dateand ship datecreate date entry every 7 daysadd 5 days to ship datehow many ordersper monthkeep only entries fordates present in left tableCSV Reader String to Date&Time Date&Time-basedRow Filter Pivoting Date&TimeDifference Column Rename Create Date&TimeRange Date&Time Shift Column Rename AggregationGranularity Column Resorter Extract Date&TimeFields Joiner

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: elisabeth.richter
Created at: 2021-03-29
On NodePit since: 2021-09-02
Last update: 2024-04-27
Created with KNIME version: v4.4.1

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

Try NodePit Runner!