Icon

Financial _​ Forecasting Periods (Simple) for Depreciation _​ Multi-Asset

Financial _ Forecasting Periods (Simple) for Depreciation _ Multi-Asset
NIME Forum's Challenge (multi-ASSET): Proposed Time Handling (Period Estimation) Solution: BasicINPUTDataOUTPUT_01WIDEFormatAggregated ReportMAXLife left (weeks) ...UPPER:Validated Active AssetsLOWERUnvalidated Out of Cycle AssetsStablish starting 'FullCycle_Period_01'and'LookingForward_Period_01'on a next monday basiscriteria... to VariableCreate Time RangeLoopThroughProjectsReporting Format to fit a MAXLife left (weeks)of AssetsCalculateDepreciation on a WeeklyBasisExtendEmpty Values to MatchReporting FormatRowIDResetOUTPUT_02Extended Report Format(Only Active ASSETS)Node 2083... to WIDEby SumAggregationon PeriodsAddressASSETName... to WIDEby SumAggregationon weekAddressASSETNameUnpivotDatesPivoting ASSETSFormatting Dates Table Creator Joiner GroupBy Rule-basedRow Splitter ProcessedINPUT Data Table Rowto Variable Create Date&TimeRange Table Row ToVariable Loop Start Reporting Format Math Formula Joiner RowID Joiner Loop End (2 ports) Pivoting ConstantValue Column Pivoting ConstantValue Column Unpivoting Pivoting String to Date&Time NIME Forum's Challenge (multi-ASSET): Proposed Time Handling (Period Estimation) Solution: BasicINPUTDataOUTPUT_01WIDEFormatAggregated ReportMAXLife left (weeks) ...UPPER:Validated Active AssetsLOWERUnvalidated Out of Cycle AssetsStablish starting 'FullCycle_Period_01'and'LookingForward_Period_01'on a next monday basiscriteria... to VariableCreate Time RangeLoopThroughProjectsReporting Format to fit a MAXLife left (weeks)of AssetsCalculateDepreciation on a WeeklyBasisExtendEmpty Values to MatchReporting FormatRowIDResetOUTPUT_02Extended Report Format(Only Active ASSETS)Node 2083... to WIDEby SumAggregationon PeriodsAddressASSETName... to WIDEby SumAggregationon weekAddressASSETNameUnpivotDatesPivoting ASSETSFormatting Dates Table Creator Joiner GroupBy Rule-basedRow Splitter ProcessedINPUT Data Table Rowto Variable Create Date&TimeRange Table Row ToVariable Loop Start Reporting Format Math Formula Joiner RowID Joiner Loop End (2 ports) Pivoting ConstantValue Column Pivoting ConstantValue Column Unpivoting Pivoting String to Date&Time

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: 2021-11-18
On NodePit since: 2021-11-27
Last update: 2024-11-21
Created with KNIME version: v4.4.2
Tags: Date HandlingMulti Asset

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

Try NodePit Runner!