Icon

09 Metanodes

09 Metanodes
Exercise: MetanodesBelow you see a workflow that performs a number of different data wrangling tasks. Actually, youcompleted them yourself earlier in the course! Structure the workflow by metanodes so that each orangeannotation and the nodes inside it make one metanode. The nodes that are not inside any annotationcan be left as they are. Database Data Manipulation Population Life Expectancy Travel Advisories Demographics.sqliteReplace :by -Extract numericrisk level into a separate columnConvert change topercentageAdd Direction columnbased on +/- changeCreate ChangecolumnAccessed columnto Date&TimeManual manipulationCount of rowsgeo_coordinates.tabletravel_advidories.csvFilter rows where max LE> 80Inner join on country nameInner join on country nameCounts by risk levelsdemographics.xlsx(population)demographics.xlsx(life_expectancy)Inner join on country nameonly year SQLite Connector String Manipulation String Manipulation Math Formula Rule Engine Math Formula String to Date&Time Table Editor DB Writer DB Table Selector DB GroupBy Table Reader CSV Reader DB Row Filter Joiner Joiner DB GroupBy Excel Reader Excel Reader Joiner Extract Date&TimeFields Exercise: MetanodesBelow you see a workflow that performs a number of different data wrangling tasks. Actually, youcompleted them yourself earlier in the course! Structure the workflow by metanodes so that each orangeannotation and the nodes inside it make one metanode. The nodes that are not inside any annotationcan be left as they are. Database Data Manipulation Population Life Expectancy Travel Advisories Demographics.sqliteReplace :by -Extract numericrisk level into a separate columnConvert change topercentageAdd Direction columnbased on +/- changeCreate ChangecolumnAccessed columnto Date&TimeManual manipulationCount of rowsgeo_coordinates.tabletravel_advidories.csvFilter rows where max LE> 80Inner join on country nameInner join on country nameCounts by risk levelsdemographics.xlsx(population)demographics.xlsx(life_expectancy)Inner join on country nameonly yearSQLite Connector String Manipulation String Manipulation Math Formula Rule Engine Math Formula String to Date&Time Table Editor DB Writer DB Table Selector DB GroupBy Table Reader CSV Reader DB Row Filter Joiner Joiner DB GroupBy Excel Reader Excel 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
Created by: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2022-01-25
Last update: 2024-11-14
Created with KNIME version: v4.5.0
Tags: metanode

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

Try NodePit Runner!