Icon

07 Loops

07 Loops
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? ReadJoinedCountryData.tableRead population2019.table Table Reader Table Reader 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? ReadJoinedCountryData.tableRead population2019.table Table Reader Table 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-10-23
On NodePit since: 2021-03-24
Last update: 2024-05-03
Created with KNIME version: v4.2.3
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!