Icon

Window loop and years

First attempt: but last row of last iteration is excluded Second attempt: working as expected! DataYear period = 5Node 3GroupDelete last rowCounterCounter descendingCounter ascendingYearGeneratingclustersStartStartBase/Group idEndStepBinning! Counter servesas groupIdOne groupId periterationGroupOne groupId periteration Excel Reader Window Loop Start Loop End GroupBy Row Filter Counter Generation Sorter Sorter Column Expressions Empty Table Creator Integer Widget Column Expressions Counter Generation Column Expressions Integer Widget Binner (Dictionary) Group Loop Start GroupBy Loop End First attempt: but last row of last iteration is excluded Second attempt: working as expected! DataYear period = 5Node 3GroupDelete last rowCounterCounter descendingCounter ascendingYearGeneratingclustersStartStartBase/Group idEndStepBinning! Counter servesas groupIdOne groupId periterationGroupOne groupId periterationExcel Reader Window Loop Start Loop End GroupBy Row Filter Counter Generation Sorter Sorter Column Expressions Empty Table Creator Integer Widget Column Expressions Counter Generation Column Expressions Integer Widget Binner (Dictionary) Group Loop Start GroupBy 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
Created by: rbarri
Created at: 2022-07-22
On NodePit since: 2022-07-23
Last update: 2024-04-27
Created with KNIME version: v4.6.0

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

Try NodePit Runner!