copy rows for missing months as in previous

[surajdhall]

Hi Experts,

Data:

LOAD * INLINE [

Product, Date, Sales

Tea, 01/01/2017, 10

Tea, 02/01/2017, 10

Coffee, 01/01/2017, 30

Coffee, 01/01/2017, 40

Coffee, 02/01/2017, 50

Tea, 01/02/2017, 10

Tea, 01/04/2017, 40

];

expected ouput-

Data:

LOAD * INLINE [

Product, Date, Sales

Tea, 01/01/2017, 10

Tea, 02/01/2017, 10

Coffee, 01/01/2017, 30

Coffee, 01/01/2017, 40

Coffee, 02/01/2017, 50

Tea, 01/02/2017, 10

Coffee, 01/02/2017, 30

Coffee, 01/02/2017, 40

Coffee, 02/02/2017, 50

Tea, 01/03/2017, 10

Coffee, 01/03/2017, 30

Coffee, 01/03/2017, 40

Coffee, 02/03/2017, 50

Coffee, 01/04/2017, 30

Coffee, 01/04/2017, 40

Coffee, 02/04/2017, 50

Tea, 01/04/2017, 40

];

In the previous dataset, there is no Feb data for Coffee. I want the same data as in the previous month(Jan) ie. 3 rows with sales 30,40,50. Similarly for Tea. The output has red rows that are expected to get generated.So the data should be brought forward till the max month in the dataset.

I looked into generating missing data by HIC, but not sure how to implement the above scenario.

Please help!

[fvelascog72 · Accepted solution]

Hi,

Try with attached file.

Saludos.

[surajdhall]

Thanks:)