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