Icon

07 Loops - Solution

Solution to an exercise for building a loop.

Build a group loop and a counting loop.

CHECK YOUR ANSWERS:

Group Loop:
The life expectancy in France is above the European average.

Counting Loop:
The loop forecasts 20 066 428 inhabitants in Chile in 2024.

Exercise: Group LoopThe first task is to build a group loop that compares the life expectancy in each country to the average value on the continent where it'slocated.1.1) Read the JoinedCountryTable.table file by executing the top Table Reader node. This table contains information about thedemographics, geolocation, and travel risks in the different countries/territories in 2020.1.2) Start a group loop that handles each continent in a separate iteration1.3) Build the loop body. - Calculate the average overall life expectancy on the continent- Transform the value into a flow variable- Use the Rule Engine node to assign each country the value "below" if their overall life expectancy is below the average and the value"above" otherwise. Append a new column.1.4) Close the loop by concatenating the rows from the different iterations. Is the life expectancy in France below or above the Europeanaverage? Exercise: Counting LoopThe second task it to build a counting loop that forecasts the population in the next five years.2.1) Read the population2019.table file, and split the country names into a separate table by executing the Table Reader and ColumnSplitter nodes2.2) Start a counting loop with 5 iterations on the top output of the Column Splitter node2.3) Forecast the population in 2020 by adding the value in the Change column to the value in the Population (2019/07/01) columnonce. Forecast the population value in 2021 by adding it two times, and so on. Use the Math Formula node. Append a new columncalled "Forecast".2.4) Rename the Forecast column differently in each iteration: - Add the current iteration value to the year 2020. Use the Math Formula (Variable) node.- Use this flow variable to create a title, for example, "Forecasted population in 2020". Use the String Manipulation (Variable) node.- Use this flow variable to rename the Forecast column2.5) Exclude all other columns2.6) Close the loop by joining the columns from the different iterations. 2.7) Join the country names to the loop output on row ID. What is the forecasted population in Chile in 2024? ReadJoinedCountryData.tableOne iterationper continentavg life expectancyby continentbelow or above thecontinent averageAdd change to currentpopulationColumn header2020 + current iterationRename column withforecasted valuesOnly forecastedvaluesRead population2019.tablecountry namesat bottominner join on rowIDconcatenatethe results5 iterations Table Reader Group Loop Start GroupBy Rule Engine Math Formula String Manipulation(Variable) Math Formula(Variable) Column Rename Loop End (ColumnAppend) Column Filter Table Rowto Variable Table Reader Column Splitter Joiner Loop End Counting Loop Start Exercise: Group LoopThe first task is to build a group loop that compares the life expectancy in each country to the average value on the continent where it'slocated.1.1) Read the JoinedCountryTable.table file by executing the top Table Reader node. This table contains information about thedemographics, geolocation, and travel risks in the different countries/territories in 2020.1.2) Start a group loop that handles each continent in a separate iteration1.3) Build the loop body. - Calculate the average overall life expectancy on the continent- Transform the value into a flow variable- Use the Rule Engine node to assign each country the value "below" if their overall life expectancy is below the average and the value"above" otherwise. Append a new column.1.4) Close the loop by concatenating the rows from the different iterations. Is the life expectancy in France below or above the Europeanaverage? Exercise: Counting LoopThe second task it to build a counting loop that forecasts the population in the next five years.2.1) Read the population2019.table file, and split the country names into a separate table by executing the Table Reader and ColumnSplitter nodes2.2) Start a counting loop with 5 iterations on the top output of the Column Splitter node2.3) Forecast the population in 2020 by adding the value in the Change column to the value in the Population (2019/07/01) columnonce. Forecast the population value in 2021 by adding it two times, and so on. Use the Math Formula node. Append a new columncalled "Forecast".2.4) Rename the Forecast column differently in each iteration: - Add the current iteration value to the year 2020. Use the Math Formula (Variable) node.- Use this flow variable to create a title, for example, "Forecasted population in 2020". Use the String Manipulation (Variable) node.- Use this flow variable to rename the Forecast column2.5) Exclude all other columns2.6) Close the loop by joining the columns from the different iterations. 2.7) Join the country names to the loop output on row ID. What is the forecasted population in Chile in 2024? ReadJoinedCountryData.tableOne iterationper continentavg life expectancyby continentbelow or above thecontinent averageAdd change to currentpopulationColumn header2020 + current iterationRename column withforecasted valuesOnly forecastedvaluesRead population2019.tablecountry namesat bottominner join on rowIDconcatenatethe results5 iterations Table Reader Group Loop Start GroupBy Rule Engine Math Formula String Manipulation(Variable) Math Formula(Variable) Column Rename Loop End (ColumnAppend) Column Filter Table Rowto Variable Table Reader Column Splitter Joiner Loop End Counting Loop Start

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-04-14
Last update: 2024-11-19
Created with KNIME version: v4.5.0
Tags: group loopcounting looploop end (column append)

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

Try NodePit Runner!