Icon

08_​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 8: Date and Time ManipulationIn this exercise you convert string values to Date&Time, extract granularities from Date&Time values, and filter databased on Date&Time values. 2a) Extract the orders thatwere submitted in 20192b) Extract the remainingorders into a separatetable 3) Extract month (innumber) and year of eachorder into separatecolumns 1) Convert order datesfrom string to Date&Time 4) (Optional) Seasonality in sales. We want to see if the total salesfluctuates in a similar pattern over the course of a year. We plot themonthly sales numbers in a line plot, each line representing differentyears. 4.1) Aggregate monthly total sales for each year. Use Pivoting, withMonth as the group and Year as the pivot. Calculate the sum of Pricein the manual aggregation4.2) Plot monthly sales in a line plot (Line Plot) with different years inseparate lines. Are there any commonalities (e.g., busy months)across different years? Transform Transaction Date into Date&Time FomatOnly 2019Before 2019Extract MonthAnd YearGroup: MonthPivot: YearAggregation: sum of PriceSales duringthe course of ayear String to Date&Time Date&Time-basedRow Filter Date&Time-basedRow Filter Read joined andpreprocessed data Extract Date&TimeFields Pivoting Line Plot Exercise 8: Date and Time ManipulationIn this exercise you convert string values to Date&Time, extract granularities from Date&Time values, and filter databased on Date&Time values. 2a) Extract the orders thatwere submitted in 20192b) Extract the remainingorders into a separatetable 3) Extract month (innumber) and year of eachorder into separatecolumns 1) Convert order datesfrom string to Date&Time 4) (Optional) Seasonality in sales. We want to see if the total salesfluctuates in a similar pattern over the course of a year. We plot themonthly sales numbers in a line plot, each line representing differentyears. 4.1) Aggregate monthly total sales for each year. Use Pivoting, withMonth as the group and Year as the pivot. Calculate the sum of Pricein the manual aggregation4.2) Plot monthly sales in a line plot (Line Plot) with different years inseparate lines. Are there any commonalities (e.g., busy months)across different years? Transform Transaction Date into Date&Time FomatOnly 2019Before 2019Extract MonthAnd YearGroup: MonthPivot: YearAggregation: sum of PriceSales duringthe course of ayear String to Date&Time Date&Time-basedRow Filter Date&Time-basedRow Filter Read joined andpreprocessed data Extract Date&TimeFields Pivoting Line Plot

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: 2023-04-06
Last update: 2024-11-04
Created with KNIME version: v4.7.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!