Help in repeating a field value till a new value is found in same field ?

[prahlad_infy]

Hello Sirs ,

I do not know how should i recur a field value till it is encountered by new value ?

LOAD * INLINE [
F1, F2, F3
XO, 20, CONFIRMED
CO, 21,
XM, 22,
CM, NV,
X1O, 34, TRANSIT
C2O, 34,
XOM, NT,
CORM, NT,
XOR, 91, DELAYED
XONT, 33,
EXO, 22,
PROG, 1,
];

like the below table for field F3  i am wanting to repeat value for the above data while loading 

F1	F2	F3
XO	20	CONFIRMED
CO	21	CONFIRMED
XM	22	CONFIRMED
CM	NV	CONFIRMED
X1O	34	TRANSIT
C2O	34	TRANSIT
XOM	NT	TRANSIT
CORM	NT	TRANSIT
XOR	91	DELAYED
XONT	33	DELAYED
EXO	22	DELAYED
PROG	1	DELAYED

Please help .

Thanks

[anushree1 · Accepted solution]

Please check the attached

[raman_rastogi]

Try this

DataTemp:
Load F1,
F2,
if(len(F3)<=0,Peek(F3),F3) as F3;
LOAD * INLINE [
F1, F2, F3
XO, 20, CONFIRMED
CO, 21,
XM, 22,
CM, NV,
X1O, 34, TRANSIT
C2O, 34,
XOM, NT,
CORM, NT,
XOR, 91, DELAYED
XONT, 33,
EXO, 22,
PROG, 1,
];

Regards

Raman