Icon

Equally distribute work package minutes by number of employees via statistics

https://forum.knime.com/t/divide-rows-into-7-even-groups-based-on-sum-of-values-in-a-column/19189 ASC so employee withmax. minutes assigneddoes not get the biggestwork packes eachiteration Work packagesAdd workpackage nameEmployeesSortDESC by min.SortDESC by min.Get countof employeesFilter employeeby itaration overwork packagesWork packagewith max. minutesUpdate assignedwork package minutesUpdate assignedwork package nameGet nextwork packagesfor amount of employeesRow count -1as row enduses index whichstarts with 0Table Creator Create Temp Dir String Manipulation Table Creator Recursive LoopStart (2 ports) Recursive LoopEnd (2 ports) Sorter Sorter Extract TableDimension Table Rowto Variable Table Row ToVariable Loop Start Row Filter Loop End Table Rowto Variable ConstantValue Column Java EditVariable (simple) String Manipulation(Variable) Rule EngineVariable ConstantValue Column Row Splitter Extract TableDimension Table Rowto Variable Math Formula(Variable) https://forum.knime.com/t/divide-rows-into-7-even-groups-based-on-sum-of-values-in-a-column/19189 ASC so employee withmax. minutes assigneddoes not get the biggestwork packes eachiteration Work packagesAdd workpackage nameEmployeesSortDESC by min.SortDESC by min.Get countof employeesFilter employeeby itaration overwork packagesWork packagewith max. minutesUpdate assignedwork package minutesUpdate assignedwork package nameGet nextwork packagesfor amount of employeesRow count -1as row enduses index whichstarts with 0Table Creator Create Temp Dir String Manipulation Table Creator Recursive LoopStart (2 ports) Recursive LoopEnd (2 ports) Sorter Sorter Extract TableDimension Table Rowto Variable Table Row ToVariable Loop Start Row Filter Loop End Table Rowto Variable ConstantValue Column Java EditVariable (simple) String Manipulation(Variable) Rule EngineVariable ConstantValue Column Row Splitter Extract TableDimension Table Rowto Variable Math Formula(Variable)

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: mw
Created at: 2019-10-31
On NodePit since: 2021-07-01
Last update: 2024-05-02
Created with KNIME version: v4.0.2

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

Try NodePit Runner!