Icon

06_​DateTime_​Manipulation

Exercise 6: Date and Time ManipulationIn this exercise you convert string values to Date&Time, extract granularities from Date&Time values, and filter data based on Date&Time values. 2a) Extract the orders that weresubmitted in 20192b) Extract the remaining ordersinto a separate table 3) Extract quarter and year of eachorder into separate columns 1) Convert order dates from stringto Date&Time Extract QuarterAnd YearTransform Transaction Date into Date&Time FomatOnly 2019Before 2019 Extract Date&TimeFields String to Date&Time Date&Time-basedRow Filter Date&Time-basedRow Filter Read joined andpreprocessed data Exercise 6: Date and Time ManipulationIn this exercise you convert string values to Date&Time, extract granularities from Date&Time values, and filter data based on Date&Time values. 2a) Extract the orders that weresubmitted in 20192b) Extract the remaining ordersinto a separate table 3) Extract quarter and year of eachorder into separate columns 1) Convert order dates from stringto Date&Time Extract QuarterAnd YearTransform Transaction Date into Date&Time FomatOnly 2019Before 2019 Extract Date&TimeFields String to Date&Time Date&Time-basedRow Filter Date&Time-basedRow Filter Read joined andpreprocessed data

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: 2019-12-07
Last update: 2024-04-25
Created with KNIME version: v4.0.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!