Icon

4. Loop on List of Values

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 these countries.
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.

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"extract data forcurrent "country"for execution speedkeep only "country"Node 28sales.csvstats onnumericalsstats onnominalsstart loop on list of unique valuesin "country" collect statsfor all countries GroupBy Row Filter Cache Column Filter Statistics CSV Reader Variable toTable Column Variable toTable Column Table Row ToVariable Loop Start Loop End 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"extract data forcurrent "country"for execution speedkeep only "country"Node 28sales.csvstats onnumericalsstats onnominalsstart loop on list of unique valuesin "country" collect statsfor all countries GroupBy Row Filter Cache Column Filter Statistics CSV Reader Variable toTable Column Variable toTable Column Table Row ToVariable Loop Start Loop End

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: 2023-01-23
Last update: 2024-04-27
Created with KNIME version: v4.5.0
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!