Icon

02_​Database_​Data_​Manipulation - Solution

02_Database_Data_Manipulation - Solution
Exercise Database Data Manipulation1) Connect to the WebActivity.sqlite database available in the "data" folder2) Select the web_activity table3) Calculate the number of customers in each web activity category4) Calculate the maximum number of customers out of all web activity categories5) Filter the aggregated table to the most popular web activity category6) Filter the original table according to the most popular web activity category7) Read the filtered data into a KNIME data table Connect to theWebActivity.sqliteSelect theweb_activity tableNumber of customers perweb activity categoryRead the filtered datain a KNIME data tableThe maximum number of customersout of all web activity categoriesMost popularweb activity categoryOriginal data forthe most popular category SQLite Connector DB Table Selector DB GroupBy DB Reader DB GroupBy DB Joiner DB Joiner Exercise Database Data Manipulation1) Connect to the WebActivity.sqlite database available in the "data" folder2) Select the web_activity table3) Calculate the number of customers in each web activity category4) Calculate the maximum number of customers out of all web activity categories5) Filter the aggregated table to the most popular web activity category6) Filter the original table according to the most popular web activity category7) Read the filtered data into a KNIME data table Connect to theWebActivity.sqliteSelect theweb_activity tableNumber of customers perweb activity categoryRead the filtered datain a KNIME data tableThe maximum number of customersout of all web activity categoriesMost popularweb activity categoryOriginal data forthe most popular categorySQLite Connector DB Table Selector DB GroupBy DB Reader DB GroupBy DB Joiner 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: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2022-03-12
Last update: 2024-11-17
Created with KNIME version: v4.1.2
Tags: e-learningdatabaseSQLiteSQLeducation

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

Try NodePit Runner!