Icon

DateTime_​Manipulation_​Example

Date and Time Manipulation 2) Extract the orders thatwere submitted in 2019 3) Extract month and year ofeach order 1) Convert order dates fromstring to Date&Time 4) Calculate number ofmonths since the last order 5) Group by month and year, sort by dates, calculatethe cumulative number of orders, and moving averagefor previous 12 months Transform Transaction Date into Date&Time FomatOnly 2019Number of monthssince the last orderExecution dateGroup by month &year, calculatethe number of ordersSort by year& monthCumulativenumber of ordersMoving averagefor 12 months(backward)Extract MonthAnd Year String to Date&Time Date&Time-basedRow Filter Date&TimeDifference Date&TimeConfiguration GroupBy Sorter Moving Aggregation Moving Average Extract Date&TimeFields Table Reader Date and Time Manipulation 2) Extract the orders thatwere submitted in 2019 3) Extract month and year ofeach order 1) Convert order dates fromstring to Date&Time 4) Calculate number ofmonths since the last order 5) Group by month and year, sort by dates, calculatethe cumulative number of orders, and moving averagefor previous 12 months Transform Transaction Date into Date&Time FomatOnly 2019Number of monthssince the last orderExecution dateGroup by month &year, calculatethe number of ordersSort by year& monthCumulativenumber of ordersMoving averagefor 12 months(backward)Extract MonthAnd Year String to Date&Time Date&Time-basedRow Filter Date&TimeDifference Date&TimeConfiguration GroupBy Sorter Moving Aggregation Moving Average Extract Date&TimeFields Table 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: Maarit Laukkanen
Created at: 2019-10-18
On NodePit since: 2021-07-22
Last update: 2024-04-27
Created with KNIME version: v4.7.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!