Icon

Conditionally substract current from previous value

Identify classificationbased on multiplevalues Split periods w/osuccessing period apart Corresponding Forum Posthttps://forum.knime.com/t/substract-actual-value-from-previous-value-under-certain-conditions/58879 Join columnsMinimumPeriodLoop perPeriod and ClassificationCreateFilter RuleFiltercorrespondingdataLoop perCol for calculationTOPColumns not forcalculaionCalculateResultRename toTEMP-ColTEMP-Col tocurrent Column NameResult Column NameRenameResultAppend Resultsto columnsnot used for calculationRename toTEMP-VarTOPMin. PeriodBOTTOMPeriods with successorConcat withrows which hadno successing periodRemoveClassificationExcel Reader String Manipulation GroupBy Group Loop Start String Manipulation(Variable) Rule-basedRow Filter Column ListLoop Start Column Splitter Column Filter Math Formula Column Rename(Regex) Column Rename(Regex) String Manipulation(Variable) Column Rename(Regex) Loop End (ColumnAppend) Column Appender Loop End Table Rowto Variable Column Rename(Regex) Reference RowSplitter Concatenate Column Filter Identify classificationbased on multiplevalues Split periods w/osuccessing period apart Corresponding Forum Posthttps://forum.knime.com/t/substract-actual-value-from-previous-value-under-certain-conditions/58879 Join columnsMinimumPeriodLoop perPeriod and ClassificationCreateFilter RuleFiltercorrespondingdataLoop perCol for calculationTOPColumns not forcalculaionCalculateResultRename toTEMP-ColTEMP-Col tocurrent Column NameResult Column NameRenameResultAppend Resultsto columnsnot used for calculationRename toTEMP-VarTOPMin. PeriodBOTTOMPeriods with successorConcat withrows which hadno successing periodRemoveClassificationExcel Reader String Manipulation GroupBy Group Loop Start String Manipulation(Variable) Rule-basedRow Filter Column ListLoop Start Column Splitter Column Filter Math Formula Column Rename(Regex) Column Rename(Regex) String Manipulation(Variable) Column Rename(Regex) Loop End (ColumnAppend) Column Appender Loop End Table Rowto Variable Column Rename(Regex) Reference RowSplitter Concatenate Column Filter

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: 2023-01-09
On NodePit since: 2023-01-10
Last update: 2024-05-01
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!