Icon

06_​DateTime_​Manipulation

DateTime Manipulation

Exercise 6 for the KNIME Analytics Platform for Data Wranglers course
- Convert a String column to Date&Time format
- Extract rows according to a 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 product purchasesthat were submitted in 20192b) Extract the remaining productpurchases into a separate table 3) Extract quarter and year of eachproduct purchase into separatecolumns 1) Convert order dates from stringto Date&Time 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 product purchasesthat were submitted in 20192b) Extract the remaining productpurchases into a separate table 3) Extract quarter and year of eachproduct purchase into separatecolumns 1) Convert order dates from stringto Date&Time 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: 2021-11-16
Last update: 2024-04-27
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!