2 Replies Latest reply: Jul 20, 2016 3:20 AM by Michael H. RSS

    Generate Missing Values / Dummy Records

    Michael H.

      Hi there

       

      Have the following table, which I want to fill with zero-values for all missing Dates.

       

      Facts:

      DateDeptVal
      01.01.2015a10
      02.01.2015a20
      10.01.2015a15
      31.01.2015a7

       

       

      There's also a calendar table with every possible date, both of the tables are connected via a date ID. So for any date in the calendar table combinated with any dept in the Facts table, I want Val to be 0 if doesn't exist in the Facts table yet.

       

      Hope my question is understandable and hope anyone can help :-)

       

      Kind regards

      Michael