Icon

20220318_​year_​range

One name - many rows (one per season) One name - many seasons - one row Same using Rank create start/endyears and row idxgroup by name+yrssort by name+rowIDNode 55Node 57Node 59Node 60Node 61create start/endyears andno. of seasonsOne row per seasonCalc yearand seasongroup byname+yrsNode 68Node 69Node 70Group by name+yearsRank by whatever you wantCalc yearand seasonNode 73Node 74 Column Expressions Group Loop Start Sorter Column Expressions Loop End Counter Generation Column Filter Table Creator Column Expressions One Row to Many Column Expressions Group Loop Start Loop End Counter Generation Column Filter Rank Column Expressions Column Filter Table Creator One name - many rows (one per season) One name - many seasons - one row Same using Rank create start/endyears and row idxgroup by name+yrssort by name+rowIDNode 55Node 57Node 59Node 60Node 61create start/endyears andno. of seasonsOne row per seasonCalc yearand seasongroup byname+yrsNode 68Node 69Node 70Group by name+yearsRank by whatever you wantCalc yearand seasonNode 73Node 74 Column Expressions Group Loop Start Sorter Column Expressions Loop End Counter Generation Column Filter Table Creator Column Expressions One Row to Many Column Expressions Group Loop Start Loop End Counter Generation Column Filter Rank Column Expressions Column Filter Table Creator

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: dustb
Created at: 2022-03-18
On NodePit since: 2022-03-18
Last update: 2024-04-27
Created with KNIME version: v4.5.1

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

Try NodePit Runner!