Activity I: Processing Date&Time data

In the data table from the Excel Reader node, convert a string column Date to Date&Time data type (String to Date&Time node)
In the resulting table, extract Month(number), Quarter and Year to new columns (Extract Date&Time Fields node)
Extract the orders that were submitted on or after January 1,2019 using the Date&Time-based Row Filter node. Set the Start as January 1, 2019, inclusive. No need to set the End.
Aggregate the quarterly total sale by a Pivot node with Quarter and Year as groups and StoreType as the pivot. Calculate the Sum of Price as the total sale amount.
Combine Year and Quarter into a single string of the form "Year/Quarter" with String Manipulation node (hint: use the string function to convert Year and Quarter into strings, then use the join function to combine them with "/" in between; join(string($Year$),"/",string($Quarter$)) ). Append the resulting new column as QuarterAndYear.
With a Stacked Area Chart node, visualize quarterly total sales of both store types (Online Store and Onsite Store), with QuarterAndYear on the Horizontal dimension.
Optional: analyze seasonality in sales:
- Let's focus on the output table from the Date&Time-based Row Filter node. Introduce another Pivot node to your workflow to aggregate monthly total sales. Use Month(number) as the group and Year as the pivot. Calculate the Sum of Price as the total sale amount.
- Plot the resulting monthly total sale data with Line Plot node. Use the column Month (Number) as the Horizontal dimension, and plot the remaining columns, each representing a year.
- Are there any commonalities (e.g., busy months) across different years?

03_Date&Time Transformation & In-Database processing - Solution

Used extensions & nodes

KNIME Base nodesTrusted extension

KNIME DatabaseTrusted extension

KNIME Excel SupportTrusted extension

KNIME JavasnippetTrusted extension

KNIME ViewsTrusted extension

Legal

KNIME Base nodes

KNIME Database

KNIME Excel Support

KNIME Javasnippet

KNIME Views