Icon

20210504 Pikairos Sum of Rows with same value in a column

There has been no description set for this workflow's metadata.

DataGroup per CodeAggregate PO Qty as sumand Count as firstRemove final result columns$Count (Sum)$*$PO Qty (First*)$Node 5Node 6CalculateSum ColumnCalculateImpact ColumnTidy Up final TableKeep onlyfinal columnsRight column OrderExcel Reader (XLS) GroupBy Column Splitter Math Formula Joiner Moving Aggregation Rule Engine Rule Engine Column Filter Column Resorter DataGroup per CodeAggregate PO Qty as sumand Count as firstRemove final result columns$Count (Sum)$*$PO Qty (First*)$Node 5Node 6CalculateSum ColumnCalculateImpact ColumnTidy Up final TableKeep onlyfinal columnsRight column OrderExcel Reader (XLS) GroupBy Column Splitter Math Formula Joiner Moving Aggregation Rule Engine Rule Engine Column Filter Column Resorter

Nodes

Extensions

Links