Icon

Inventory_​Last_​suported Invoices - KNIME Forum (91929)_​updated

All Invoices
Table Creator
Inventory
Table Creator
Joiner
by COMPANY
Group Loop Start
Top: included invoicesminus the last one
Row Splitter
Loop End
Concatenate
if( $["Cumulative Total"]=$["QTY INVENTORY"],1, $["Cumulative Total"]>$["QTY INVENTORY"],2, 0)
Expression
by COMPANYand INVOICE_DATE
Sorter
INVOICE_DATEDESC
Top k Row Filter
String to Number
https://hub.knime.com/s/7CeuJtkxXz9SuYr_
Cumulative Sum for Grouping

Nodes

Extensions

Links