Icon

Conditionally substract current from previous value 2

Identifyclassificationbased on multiplevalues Split periods w/osuccessing periodapart Corresponding ForumPosthttps://forum.knime.com/t/substract-actual-value-from-previous-value-under-certain-conditions/58879 Node 2Join columns MinimumPeriodLoop perPeriod and ClassificationCreateFilter RuleFiltercorrespondingdataLoop perCol for calculationTOPColumns not forcalculaionNode 17CalculateResultRename toTEMP-ColTEMP-Col tocurrent Column NameResult Column NameRenameResultNode 26Append Resultsto columnsnot used for calculationNode 28Node 29Rename toTEMP-VarTOPMin. PeriodBOTTOMPeriods with successorConcat withrows which hadno successing periodRemoveClassificationNode 34Join columnsMinimumDateTOPMin. PeriodBOTTOMPeriods with successorLoop perPeriod and ClassificationNode 39CreateFilter RuleFiltercorrespondingdataNode 42Node 43Node 44Node 45Excel 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 CSV Reader String Manipulation GroupBy Reference RowSplitter Group Loop Start String to Date&Time String Manipulation(Variable) Rule-basedRow Filter Column Renamer Table Rowto Variable Date&Time Shift Date&Time to String Identifyclassificationbased on multiplevalues Split periods w/osuccessing periodapart Corresponding ForumPosthttps://forum.knime.com/t/substract-actual-value-from-previous-value-under-certain-conditions/58879 Node 2Join columns MinimumPeriodLoop perPeriod and ClassificationCreateFilter RuleFiltercorrespondingdataLoop perCol for calculationTOPColumns not forcalculaionNode 17CalculateResultRename toTEMP-ColTEMP-Col tocurrent Column NameResult Column NameRenameResultNode 26Append Resultsto columnsnot used for calculationNode 28Node 29Rename toTEMP-VarTOPMin. PeriodBOTTOMPeriods with successorConcat withrows which hadno successing periodRemoveClassificationNode 34Join columnsMinimumDateTOPMin. PeriodBOTTOMPeriods with successorLoop perPeriod and ClassificationNode 39CreateFilter RuleFiltercorrespondingdataNode 42Node 43Node 44Node 45Excel 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 CSV Reader String Manipulation GroupBy Reference RowSplitter Group Loop Start String to Date&Time String Manipulation(Variable) Rule-basedRow Filter Column Renamer Table Rowto Variable Date&Time Shift Date&Time to String

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: 2025-03-27
Last update: 2025-04-24
Created with KNIME version: v5.4.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!