This content has been marked as final. Show 2 replies
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.
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
any suggestions ?