Icon

06_​DateTime_​Manipulation_​Solution

DateTime Manipulation - Solution

Solution to exercise 6 for the KNIME Analytics Platform for Data Wranglers course
- Convert a String column to Date&Time format
- Extract rows according to date value
- Extract date fields from a date column


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 Transform Transaction Date into Date&Time FomatOnly 2019Before 2019Extract QuarterAnd Year String to Date&Time Date&Time-basedRow Filter Date&Time-basedRow Filter Read joined andpreprocessed data Extract Date&TimeFields 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 Transform Transaction Date into Date&Time FomatOnly 2019Before 2019Extract QuarterAnd Year String to Date&Time Date&Time-basedRow Filter Date&Time-basedRow Filter Read joined andpreprocessed data Extract Date&TimeFields

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: 2022-10-29
Last update: 2024-11-04
Created with KNIME version: v4.4.0
Tags: datedate&timefilterETLeducation

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

Try NodePit Runner!