Icon

justknimeit02 - 04 - Raffaello Barri

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

Assumptions- there might be expenditure of yearsprevious than 2022- projects might have same names indifferent areas So there is one singlerow for a combination ofyear, area and projectFor each year,area, projectEmpty tableYearAreaProjectDateExpenditureGranularityNumber of rowsLagDate lagPeriodMonth lagFor each year,area, projectCalculationcolumnsdeletedData GroupBy Table Row ToVariable Loop Start Empty Table Creator Column Expressions Rule Engine Rule EngineVariable Counter Generation Date&Time Shift Rule EngineVariable Rule EngineVariable Loop End Column Filter Table Creator Assumptions- there might be expenditure of yearsprevious than 2022- projects might have same names indifferent areas So there is one singlerow for a combination ofyear, area and projectFor each year,area, projectEmpty tableYearAreaProjectDateExpenditureGranularityNumber of rowsLagDate lagPeriodMonth lagFor each year,area, projectCalculationcolumnsdeletedData GroupBy Table Row ToVariable Loop Start Empty Table Creator Column Expressions Rule Engine Rule EngineVariable Counter Generation Date&Time Shift Rule EngineVariable Rule EngineVariable Loop End Column Filter Table Creator

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: rbarri
Created at: 2023-04-17
On NodePit since: 2023-04-19
Last update: 2024-04-27
Created with KNIME version: v4.7.2
Tags: lellobajustknimeitJKISeason2-4

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

Try NodePit Runner!