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 ?
