Next table value if null

[maestro444]

TIME                              FILENAME          VALUE1               VALUE2

2012.11.26 00:01:17	AAEU.csv	0	1.29662
2012.11.26 00:01:17	INEU.csv	1.2967	0
2012.11.26 00:01:18	AAEU.csv	0	1.29666
2012.11.26 00:01:19	AAEU.csv	0	1.29669
2012.11.26 00:01:20	AAEU.csv	0	1.29669
2012.11.26 00:01:49	AAEU.csv	0	1.29669
2012.11.26 00:02:02	AAEU.csv	0	1.29671
2012.11.26 00:02:02	INEU.csv	1.29671	0
2012.11.26 00:02:07	AAEU.csv	0	1.296855
2012.11.26 00:02:08	AAEU.csv	0	1.29681

Hello, is there any function that can help solving following issue?

I have a range of values which i want to compare by time,

I need the following logic: If row value equals to zero, then take previous value which is not equal to zero.

I've tried previous function, but I made mistake in the formula, as I am not familiar with creating counters. And looks like some kind of counters should be created there to pick the right value avove.

=IF(VALUE1=0,previous(VALUE1),VALUE1 as VALUE1_COUNTED,

Would be very thankful for any hints.

[Gysbert_Wassenaar · Accepted solution]

It's not clear to me what you want. Try this and see if it does what you need:

LOAD Time,

     filename,

     if(rowno()=1 or INEU<>0,INEU,peek('NewINEU')) as NewINEU,

     AAEU

FROM Data.skv

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[maestro444]

Thanks! That's exactly what I wanted.