Fill empty field with the last value

[Anonymous]

Dear specilialist,

I need to fill fields without value with the previous value in that field

So :

25     A

778    

44

55

77     B

44

12

12     C

33

Needs to become:

25     A

778   A

44     A

55     A

77     B

44     B

12     B

12     C

33     C

I tried  to use Peek() and Previous() but that doesn't work. Maybe I am using it wrong.

Please take a look at the atteched files.

PS my orginal data is not in Excal so I can not use the fill function in the wizard

[swuehl · Accepted solution]

Hi you just need to reference your renamed field A2 in peek function:

LOAD If (ISNULL(A), Peek(A2) , A) as A2,

B as B2  

FROM

Schedule.xlsx

(ooxml, no labels);

Regards,

Stefan

[Anonymous]

Yes that's it. I overlooked that.

Thanks!