Icon

01 Data and Time and Databases

Task 1: Date and Time Manipulation Task 2: Database Data Manipulation Note: I used the Accommodation.sqlite from theKNIME lab to match the exercises and since noother sqlite data was provided Removed time valuesCount by County/CustomerExtract day of week from timestampsGlobal Data Superstore.csvFilter: Quantity > 3 Read datainto KNIMECreate table:Total_Amount Avg Profit by SalesRemove timeJoined sales info to originaldata Modify Time GroupBy Sorter Extract Date&TimeFields CSV Reader DB Row Filter DB Reader SQLite Connector DB Writer DB GroupBy Modify Time DB Joiner Task 1: Date and Time Manipulation Task 2: Database Data Manipulation Note: I used the Accommodation.sqlite from theKNIME lab to match the exercises and since noother sqlite data was provided Removed time valuesCount by County/CustomerExtract day of week from timestampsGlobal Data Superstore.csvFilter: Quantity > 3 Read datainto KNIMECreate table:Total_Amount Avg Profit by SalesRemove timeJoined sales info to originaldataModify Time GroupBy Sorter Extract Date&TimeFields CSV Reader DB Row Filter DB Reader SQLite Connector DB Writer DB GroupBy Modify Time DB Joiner

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: Rena
Created at: 2023-03-09
On NodePit since: 2023-03-10
Last update: 2024-09-06
Created with KNIME version: v4.7.0

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

Try NodePit Runner!