Icon

Looping for quantity balance per SKU

Wanted quantityqunatity avaibleExecute one line at a timeclosing slitQuantity as variablesplit linesexclude original quantity columniinclude a default columnclosing first chunckExecute one line at a timeexclude original quantity columniinclude a default columnQuantity as variablesplitclosing splitclosing chunckjoin just lines balance != 0include a balance columnExcel Reader (XLS) Excel Reader (XLS) Chunk Loop Start Loop End Table Rowto Variable Counting Loop Start Column Filter Math Formula Loop End Chunk Loop Start Column Filter Math Formula Table Rowto Variable Counting Loop Start Loop End Loop End Joiner (Labs) Math Formula Math Formula Wanted quantityqunatity avaibleExecute one line at a timeclosing slitQuantity as variablesplit linesexclude original quantity columniinclude a default columnclosing first chunckExecute one line at a timeexclude original quantity columniinclude a default columnQuantity as variablesplitclosing splitclosing chunckjoin just lines balance != 0include a balance columnExcel Reader (XLS) Excel Reader (XLS) Chunk Loop Start Loop End Table Rowto Variable Counting Loop Start Column Filter Math Formula Loop End Chunk Loop Start Column Filter Math Formula Table Rowto Variable Counting Loop Start Loop End Loop End Joiner (Labs) Math Formula Math Formula

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: Rafa
Created at: 2020-08-21
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.2.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!