Icon

Data Wrangling _​ Deconstructing Aggregated Values

Data Wrangling _ Deconstructing Aggregated Values

Data Wrangling _ Deconstructing Aggregated Values

Workflow created for the KNIME forum ...

https://forum.knime.com/t/calculate-single-month-values-from-pivot-with-cumulative-values/37707

DESCRIPTION:
The challenge is to to deconstruct aggregated values from a transformed data, that is shaped in a timeline format (months in columns), and return the single values of the aggregation with the same format arrangement.


For any comment or bug realted to the workflow, please do not hesitate to leave your comment.

DISCLAIMER:
The sharing of knowledge in KNIME Hub by using these examples and models, have only demonstration purposes in the advantage of the KNIME community.
These are meant to clarify theoretical background of mentioned subjects in caption.
I will not be held responsibility for any damages arising from the use of these models in your investment/valuation related work, without taking formal advise.

Cumulative Challenge setting up: Data Wrangling: Deconstructed ValuesOutput: Aggregation deconstruct (time-series' data habitat is in column): Authentication toGoogle ServicesSheet120211130_single_from_cumulativeSheets Conector/My Drive/KNIME_publicThe Datayour workflow starts hereArrangedPivot WithDeconstructed Values...row toVariableLoopping Throughout All RowsUnpivoting the MonthsPivoting the IDsMoving Aggregation of2 rows ...current_inLoopdeconstructedUnpivotingthe IDsPivoting the MonthsResetID Namefrom VariableResetID HeaderCollectDatacurrent_accountin Loop(Generic ID Name)for ID Name GoogleAuthentication Google SheetsReader Google SheetsConnection String To Number RowID Table Rowto Variable Group Loop Start Unpivoting Pivoting Moving Aggregation Math Formula Unpivoting Pivoting ConstantValue Column Column Rename Loop End ConstantValue Column Cumulative Challenge setting up: Data Wrangling: Deconstructed ValuesOutput: Aggregation deconstruct (time-series' data habitat is in column): Authentication toGoogle ServicesSheet120211130_single_from_cumulativeSheets Conector/My Drive/KNIME_publicThe Datayour workflow starts hereArrangedPivot WithDeconstructed Values...row toVariableLoopping Throughout All RowsUnpivoting the MonthsPivoting the IDsMoving Aggregation of2 rows ...current_inLoopdeconstructedUnpivotingthe IDsPivoting the MonthsResetID Namefrom VariableResetID HeaderCollectDatacurrent_accountin Loop(Generic ID Name)for ID Name GoogleAuthentication Google SheetsReader Google SheetsConnection String To Number RowID Table Rowto Variable Group Loop Start Unpivoting Pivoting Moving Aggregation Math Formula Unpivoting Pivoting ConstantValue Column Column Rename Loop End ConstantValue Column

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-30
On NodePit since: 2021-12-06
Last update: 2024-04-27
Created with KNIME version: v4.4.2

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

Try NodePit Runner!