Icon

07 Loops

07 Loops - Solution
One iterationper continentavg IT Ownerbelow or above theITOwnerAdd change to currentpopulationColumn header2020 + current iterationRename column withforecasted valuesOnly forecastedvaluesseniorityinner join on rowIDconcatenatethe results5 iterationshelpdeskhelpdeskGroup Loop Start GroupBy Rule Engine Math Formula String Manipulation(Variable) Math Formula(Variable) Column Rename Loop End (ColumnAppend) Column Filter Table Rowto Variable Column Splitter Joiner Loop End Counting Loop Start CSV Reader CSV Reader One iterationper continentavg IT Ownerbelow or above theITOwnerAdd change to currentpopulationColumn header2020 + current iterationRename column withforecasted valuesOnly forecastedvaluesseniorityinner join on rowIDconcatenatethe results5 iterationshelpdeskhelpdeskGroup Loop Start GroupBy Rule Engine Math Formula String Manipulation(Variable) Math Formula(Variable) Column Rename Loop End (ColumnAppend) Column Filter Table Rowto Variable Column Splitter Joiner Loop End Counting Loop Start CSV Reader CSV Reader

Nodes

Extensions

Links