Icon

Data Wrangling _​ Project Compare - Setting Start Year

Workflow created for the KNIME forum ...

https://forum.knime.com/t/filter-columns-with-missing-values-per-row-up-to-the-column-that-has-a-value/38376

DESCRIPTION:
The challenge is to compare different projets that start at different times, the request is to align the starting of all the projects at a T01 by removing missing values happening before.

The challenge proposed not to use Loop nodes to do so but, I still think this is anyhow a very efficient approach.

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.

Projects Compare: DATAArrangeLONGWindow Lengthfrom VariableAggregation == FirstSendRows ...Rank Ordinal from Starting Year... To VariableLoop Startby ProjectRemove Inactive Yarsbefore StartCollectDataTransformback to Wideby Ranked YearsAdd 'Years'String toRank Table Creator Unpivoting Moving Aggregation Extract TableDimension Rank Table Columnto Variable Group Loop Start Rule-basedRow Filter Loop End(deprecated) Pivoting String Manipulation Projects Compare: DATAArrangeLONGWindow Lengthfrom VariableAggregation == FirstSendRows ...Rank Ordinal from Starting Year... To VariableLoop Startby ProjectRemove Inactive Yarsbefore StartCollectDataTransformback to Wideby Ranked YearsAdd 'Years'String toRank Table Creator Unpivoting Moving Aggregation Extract TableDimension Rank Table Columnto Variable Group Loop Start Rule-basedRow Filter Loop End(deprecated) Pivoting String Manipulation

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-12-22
On NodePit since: 2021-12-25
Last update: 2026-01-15
Created with KNIME version: v4.7.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!