Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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);
Thanks! That's exactly what I wanted.