Icon

4. Loop on List of Values

Loop on List of Values
Workflow: Loop on List of Values This workflow loops on a list of unique values, in this case on a list of countries.The goal of the workflow is to identify the countries included in the file sales.csv and calculate some statistics on sold products for each one of thesecountries.First we read the data and we isolate the list of unique countries using a GroupBy node with group column "country" and no aggregation parameters.Then we pass the list of countries to a Table Row to Variable Loop Start node. This node takes the country one at a time and passes it to the loop body.In the loop body the data about the current country are isolated and statistics on sold products is calculated.Finally stats numbers are collected in the Loop End (2 ports) node. get just list of countriesunique values in "country"start loop on list of unique valuesin "country" extract data forcurrent "country"for execution speedkeep only "country"sales.csvNode 28collect statsfor all countriesstats onnumericalsstats onnominals GroupBy Table Row ToVariable Loop Start Row Filter Cache Column Filter File Reader Statistics Loop End (2 ports) Variable toTable Column Variable toTable Column Workflow: Loop on List of Values This workflow loops on a list of unique values, in this case on a list of countries.The goal of the workflow is to identify the countries included in the file sales.csv and calculate some statistics on sold products for each one of thesecountries.First we read the data and we isolate the list of unique countries using a GroupBy node with group column "country" and no aggregation parameters.Then we pass the list of countries to a Table Row to Variable Loop Start node. This node takes the country one at a time and passes it to the loop body.In the loop body the data about the current country are isolated and statistics on sold products is calculated.Finally stats numbers are collected in the Loop End (2 ports) node. get just list of countriesunique values in "country"start loop on list of unique valuesin "country" extract data forcurrent "country"for execution speedkeep only "country"sales.csvNode 28collect statsfor all countriesstats onnumericalsstats onnominals GroupBy Table Row ToVariable Loop Start Row Filter Cache Column Filter File Reader Statistics Loop End (2 ports) Variable toTable Column Variable toTable Column

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2020-05-26
Last update: 2024-04-26
Created with KNIME version: v4.1.2
Tags: BooksKNIME Advanced LuckLoop on List of ValuesLoop End (2 Ports)Table Row To Variable Loop Startflow controlloop row by row

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

Try NodePit Runner!