2 Replies Latest reply: Jul 19, 2012 12:44 PM by Andreas Dippel RSS

    Finding NULL (missing) values

      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_IDhourUNITDATA
      51120
      52115
      5318
      5613
      5718

      any suggestions ?