Create Missing Period Rows

Inserts additional rows for missing periods in a data set. The input data set must have a defined year and month column, as configured on this component. A calendar is generated between start period and end period each defined in yyyymm format. Any missing periods are then included in the dataset which is then sorted into year month order so that the rows are included in the appropriate place.

@takbb Brian Bates 25th June 2021

Input ports

1. Type: Table
   Input Data
   Data set containing data by year, month

Output ports

1. Type: Table
   Output Data
   Data set with additional year, month rows inserted