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