Icon

Exercise1

Chapter 4 / Exercise 1

This exercise is about applying some DateTime Manipulation nodes.

Workflow: Chapter4/Exercise1 This exercise is about applying some DateTimeManipulation nodes. # cars sold andsum(amount) ofmoney made byMonth# cars sold andsum(amount) ofmoney made byWeekdayrm rows withmissing valuesExtract data rows falling intime window30.03.2009 - 30.03.2011rm timesbecause they are all 12:00Add a sale date to 170 car data rows. Sales dates are between 30.Jun.2008 and 30.Jun.2011date_time_ex2.csvto be used in exercise 2cars-85.csvon RowIDleft outer joinextract year, month, dayday of week GroupBy GroupBy Missing Value Date&Time-basedRow Filter Modify Time Create Date&TimeRange CSV Writer CSV Reader Joiner Extract Date&TimeFields Workflow: Chapter4/Exercise1 This exercise is about applying some DateTimeManipulation nodes. # cars sold andsum(amount) ofmoney made byMonth# cars sold andsum(amount) ofmoney made byWeekdayrm rows withmissing valuesExtract data rows falling intime window30.03.2009 - 30.03.2011rm timesbecause they are all 12:00Add a sale date to 170 car data rows. Sales dates are between 30.Jun.2008 and 30.Jun.2011date_time_ex2.csvto be used in exercise 2cars-85.csvon RowIDleft outer joinextract year, month, dayday of weekGroupBy GroupBy Missing Value Date&Time-basedRow Filter Modify Time Create Date&TimeRange CSV Writer CSV Reader Joiner 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
On NodePit since: 2023-01-23
Last update: 2024-04-28
Created with KNIME version: v4.4.0
Tags: BooksKNIME Advanced LuckDate TimeDateTimeexercise

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

Try NodePit Runner!