Icon

Add missing months to dataset Mult Locs

Add missing months to dataset

This workflow adds missing months for each year in the dataset

Months
Table Creator
Excel Reader
Get unique years from file
GroupBy
Combine years and months
Cross Joiner
Left join
Joiner
Add Quarters
Rule Engine
Replace the empty values with 0
Missing Value
Node 7
Sorter
Row Filter
Add MonthNames
Rule Engine
Add Neighborhood
Column Expressions
GroupBy
Table Row to Variable Loop Start
Loop End

Nodes

Extensions

Links