Icon

08 Database Data Manipulation

Exercise for manipulating data on a database.

Select a table on the database and aggregate and filter the data directly on the database.












Exercise: Database Data Manipulation1) Execute the metanode below. It writes the joined table containing demographics, travel advisory, andgeocoordinates information into a SQLite database. 2) Select the JoinedTable table on the database3) Calculate the number of rows (countries) in the database table4) Filter the table to countries where the maximum overall life expectancy is > 805) Calculate the numbers of countries with life expectancy >80 in each travel risk category. What is the most commoncategory among these countries? How many countries belong to the risk category 3 (Reconsider travel)? 12 countries for category 3 Node 39Node 40Node 41Node 42 Write joineddata to database DB Table Selector DB GroupBy DB Row Filter DB GroupBy Exercise: Database Data Manipulation1) Execute the metanode below. It writes the joined table containing demographics, travel advisory, andgeocoordinates information into a SQLite database. 2) Select the JoinedTable table on the database3) Calculate the number of rows (countries) in the database table4) Filter the table to countries where the maximum overall life expectancy is > 805) Calculate the numbers of countries with life expectancy >80 in each travel risk category. What is the most commoncategory among these countries? How many countries belong to the risk category 3 (Reconsider travel)? 12 countries for category 3 Node 39Node 40Node 41Node 42 Write joineddata to database DB Table Selector DB GroupBy DB Row Filter DB GroupBy

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: 2023-03-09
Last update: 2024-05-01
Created with KNIME version: v4.7.0
Tags: sqlitedatabase

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

Try NodePit Runner!