Icon

Binning Challenge

<p>Workflow for allocating groups of items into fixed size.<br><br>See forum item link for description of challenge.</p><p></p><p></p><p>@takbb Brian Bates 25 Jan 2025</p>
SAMPLE A
Table Creator
specify bin size
Variable Creator
make every single itema row
One Row to Many
calculate new cumulativequantityoriginally was going to use rownumber, in which caseno need to calc cumul qty, but it was pointedout we need to allow for there being rowswith qty=0
Moving Aggregator
assign binbased on cumulative qtydivided by bin size (eg 1000)
Math Formula
group by bin numberto get start group, end groupand bin qty
GroupBy
required columnnames
Column Renamer
tidy up
Column Filter
reset quantity to 1for each row,unless existing qty is 0in which case 0
Rule Engine
rows to create per current rowallow for creating 1 row even whereqty = 0
Rule Engine
SAMPLE B
Table Creator
ignore suppliedcumul aggregationas we won't be using it
Column Filter

Nodes

Extensions

Links