Fill up the rows with values in existing fields

[Lokesh_5045]

Hi Experts,

The requirement is quite simple. I have the data for current month and Null values for future months. My input table will be like this (take any random numbers if you want).

ID	Month	M1	M2	M3	M4
A	July	33	23	5	99
A	August	-	-	-	-
A	September	-	-	-	-
A	October	-	-	-	-

In the above table a few values need to be replaced with top row like below. My required output is like below.

ID	Month	M1	M2	M3	M4
A	July	33	23	5	99
A	August	23	5	99	0
A	September	5	99	0	0
A	October	99	0	0	0

I need this in load script. Please help me with script or any hints.

[vinieme12]

can you post some sample data in excel that best represents the actual data you will be working with

[Lokesh_5045]

@vinieme12  Sample data also looks like this. But it contains 12 fields. Sharing the sample data.
In sheet 2, expected output is given.

Values are null beyond current month and we need to fill values based on current month data.
We shouldn't change past months data. We have to fill future months data based on current month as shown in sheet 2 in Excel.

Please refer sheet 1 (Input) and sheet 2 (Expected output) in the attached file.