Icon

02 Flow Variables and Components - Solution

02 Flow Variables and Components - Exercise (Solution)

This workflow shows a solution to a hands-on exercise in the L2-DW Introduction to KNIME Analytics Platform for Data Wranglers - Advanced course

Task 1: Use Flow VariablesRead the JoinedCountryTable.table file by executing the Table Reader node. This table containsinformation about the demographics, geolocation, and travel risks in the different countries/territoriesin 2020. Your task is to find the northmost country/territory in the data via the following steps:1. Calculate first the maximum latitude value in the data2. Transform it into a flow variable3. Filter the data by this flow variable Task 2: Create a ComponentsExecute the provided workflow. It filters the data to the northmost country or territory in the data. Yourtask is to extend it into a component that returns the northmost country/region by continent via thefollowing steps:1. Create a Value Selection Configuration node to select one of the UN continental regions in the data2. Add a Row Filter node before the GroupBy node to filter the data by the selected continent3. Encapsulate the workflow into a component. Make sure you add a data output to the component. Task 3: Use a Shared ComponentYour task is to compare how fast/slow the population increases in different countries. Build achoropleth world map via the following steps:1. Drag and drop the Choropleth World Map shared component from the KNIME Hub2. Select the Country/Territory and Change (population) columns in its configuration dialog3. Open the component’s interactive view JoinedCountryData.tableMaximum latitudeFilter to the northmost countryor territoryLife expectancy bycountries Table Reader GroupBy Rule-basedRow Filter Table Rowto Variable Northmost countryby continent ChoroplethWorld Map Task 1: Use Flow VariablesRead the JoinedCountryTable.table file by executing the Table Reader node. This table containsinformation about the demographics, geolocation, and travel risks in the different countries/territoriesin 2020. Your task is to find the northmost country/territory in the data via the following steps:1. Calculate first the maximum latitude value in the data2. Transform it into a flow variable3. Filter the data by this flow variable Task 2: Create a ComponentsExecute the provided workflow. It filters the data to the northmost country or territory in the data. Yourtask is to extend it into a component that returns the northmost country/region by continent via thefollowing steps:1. Create a Value Selection Configuration node to select one of the UN continental regions in the data2. Add a Row Filter node before the GroupBy node to filter the data by the selected continent3. Encapsulate the workflow into a component. Make sure you add a data output to the component. Task 3: Use a Shared ComponentYour task is to compare how fast/slow the population increases in different countries. Build achoropleth world map via the following steps:1. Drag and drop the Choropleth World Map shared component from the KNIME Hub2. Select the Country/Territory and Change (population) columns in its configuration dialog3. Open the component’s interactive view JoinedCountryData.tableMaximum latitudeFilter to the northmost countryor territoryLife expectancy bycountriesTable Reader GroupBy Rule-basedRow Filter Table Rowto Variable Northmost countryby continent ChoroplethWorld Map

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-10-23
On NodePit since: 2023-09-25
Last update: 2024-04-27
Created with KNIME version: v4.6.3
Tags: education

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

Try NodePit Runner!