Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
i have a problem with finding missing values.
The Database was programmed quite efficient, so there are no empty cells.
if there is an hour with no data, the whole line with
S_ID, hour, UNIT, DATA
is not written.
I tried some of the usual expressions to find NULL, but it doesnt work here.
IF(len(DATA)=0,'NULL')
IsNull(DATA)
the cells are not empy, they just dont exist.
its like a box full of eggs, i should have 10, but i get a box of 6. since the box of 6 is FULL, there seems to be no error, BUT 2 eggs are missing.
i thought about somehow connecting the DATA and a HOUR field from a seperate calendar.
The table looks like this
S_ID | hour | UNIT | DATA |
---|---|---|---|
5 | 1 | 1 | 20 |
5 | 2 | 1 | 15 |
5 | 3 | 1 | 8 |
5 | 6 | 1 | 3 |
5 | 7 | 1 | 8 |
any suggestions ?
no se si ya hallas probrado con el Null()
SI (len (DATA) = 0, 'NULL()')
IsNull (DATA)
saludos espero te ayude
i have allready tried that, this doesnt work. the field is not empty, the whole row is missing,
because of the missing rows, peek() is not working too.
i somehow have to check every hour, if there is a corresponding DATA field. if not, 'NULL'