Icon

Data Wrangling _​ Project Compare - Setting Start Year

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

Projects Compare: DATAArrangeLONGWindow Lengthfrom VariableAggregation == FirstSendRows ...Rank Ordinal from Starting Year... To VariableLoop Startby ProjectRemove Inactive Yarsbefore StartCollectDataTransformback to Wideby Ranked YearsRank to StringAdd 'Years'String toRankAdd zero toLeft Table Creator Unpivoting Moving Aggregation Extract TableDimension Rank Table Columnto Variable Group Loop Start Rule-basedRow Filter Loop End Pivoting Number To String String Manipulation Math Formula Projects Compare: DATAArrangeLONGWindow Lengthfrom VariableAggregation == FirstSendRows ...Rank Ordinal from Starting Year... To VariableLoop Startby ProjectRemove Inactive Yarsbefore StartCollectDataTransformback to Wideby Ranked YearsRank to StringAdd 'Years'String toRankAdd zero toLeft Table Creator Unpivoting Moving Aggregation Extract TableDimension Rank Table Columnto Variable Group Loop Start Rule-basedRow Filter Loop End Pivoting Number To String String Manipulation Math Formula

Nodes

Extensions

Links