Icon

Sample Data_​Bruno Updated

Sample Data_Bruno

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

DataStart LoopLag Columnfor Qty (P3M)Lag Columnfor Qty (P4M)End LoopNode 14All MonthsLeft join to addmissingmonthsInner join withmonths fromoriginal datasetto removethe missing monthsthat were addedAggregate Qtyby ID, Store, DateNode 19Table Creator Group Loop Start Lag Column Lag Column Loop End Extract Date&TimeFields Table Creator Joiner Joiner GroupBy Sorter DataStart LoopLag Columnfor Qty (P3M)Lag Columnfor Qty (P4M)End LoopNode 14All MonthsLeft join to addmissingmonthsInner join withmonths fromoriginal datasetto removethe missing monthsthat were addedAggregate Qtyby ID, Store, DateNode 19Table Creator Group Loop Start Lag Column Lag Column Loop End Extract Date&TimeFields Table Creator Joiner Joiner GroupBy Sorter

Nodes

Extensions

Links