Icon

20230317_​sum_​horizontally_​conditional_​v0

20230317_sum_horizontally_conditional

https://forum.knime.com/t/sum-horizontally-from-left-to-right-until-i-meet-a-0/63821

sample dataloop stepping on rowid == $column1$(by rows)row tolong shapevalue column aggregated productlogic factornew conditional valueget number of rows ...to variableback to wide shapesum conditionalcolumnsconditional tableappend sum conditional resulting columnTable Creator Group Loop Start Unpivoting Moving Aggregation Rule Engine Math Formula Extract TableDimension Table Rowto Variable Pivoting Column Aggregator Loop End Joiner sample dataloop stepping on rowid == $column1$(by rows)row tolong shapevalue column aggregated productlogic factornew conditional valueget number of rows ...to variableback to wide shapesum conditionalcolumnsconditional tableappend sum conditional resulting columnTable Creator Group Loop Start Unpivoting Moving Aggregation Rule Engine Math Formula Extract TableDimension Table Rowto Variable Pivoting Column Aggregator Loop End Joiner

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: RE90273
Created at: 2023-03-17
On NodePit since: 2023-03-17
Last update: 2024-05-02
Created with KNIME version: v4.7.0

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

Try NodePit Runner!