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. Population Life Expectancy Travel Advisories Database Data Manipulation Demographics.sqlitetravel_advidories.csvgeo_coordinates.tableReplace :by -Extract numericrisk level into a separate columnConvert change topercentageAdd Direction columnbased on +/- changeCreate ChangecolumnAccessed columnto Date&TimeOnly yearManual manipulationInner join on country nameInner join on country nameInner join on country nameCount of rowsFilter rows where max LE> 80Counts by risk levelsdemographics.xlsx(population)demographics.xlsx(life_expectancy) SQLite Connector File Reader Table Reader String Manipulation String Manipulation Math Formula Rule Engine Math Formula String to Date&Time Extract Date&TimeFields Table Editor Joiner Joiner Joiner DB Writer DB Table Selector DB GroupBy DB Row Filter DB GroupBy Excel Reader Excel Reader 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. Population Life Expectancy Travel Advisories Database Data Manipulation Demographics.sqlitetravel_advidories.csvgeo_coordinates.tableReplace :by -Extract numericrisk level into a separate columnConvert change topercentageAdd Direction columnbased on +/- changeCreate ChangecolumnAccessed columnto Date&TimeOnly yearManual manipulationInner join on country nameInner join on country nameInner join on country nameCount of rowsFilter rows where max LE> 80Counts by risk levelsdemographics.xlsx(population)demographics.xlsx(life_expectancy)SQLite Connector File Reader Table Reader String Manipulation String Manipulation Math Formula Rule Engine Math Formula String to Date&Time Extract Date&TimeFields Table Editor Joiner Joiner Joiner DB Writer DB Table Selector DB GroupBy DB Row Filter DB GroupBy Excel Reader Excel Reader

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: 2021-02-25
Last update: 2024-11-21
Created with KNIME version: v4.3.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!