Icon

Add missing months a nd quarters to dataset

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
Replace the empty values with 0
Missing Value
Node 7
Sorter
Add Missing Quarters
Rule Engine

Nodes

Extensions

Links