How to get previous available data

[#1]

Hello All,

I have data in table as below:

Field1, Field2, Year, Month, Value

f1a, f2a, 2013, 01, 10

f1b, f2b, 2013, 02, 20

f1c, f2c, 2013, 03, 30

f1d, f2d, 2013, 04, 40

f1e, f2e, 2013, 05, 50

f1f, f2f,  2013, 06, 60

f1g, f2g, 2013, 07, 70

f1h, f2h, 2013, 08, 80

f1h, f2h, 2013, 10, 90

Now here, in the above table i have data till aug (i.e month08). and no data for 9.

so same value of month8 should be forwarded to 9.

similarly, value of month 10 should be forwarded to 11, 12.

[MayilVahanan]

Hi

Try with this

PFA

[tresesco]

If I go with Mayil's way, it would require a small correction:

.....

Temp:

Load IterNo() as Month AutoGenerate 1 While IterNo()<=12;

Left Join

Load Field1, Field2 , Year Resident Data;                    // add Field2, Year for generic solution

...........

Update: Yes, Oredr By has to so as well.