4 Replies Latest reply: Sep 6, 2017 5:25 PM by Robson Luiz Cazetto Candeo RSS

    generating missing months

    Robson Luiz Cazetto Candeo

      I Know that has dozens of posts, but none of them solved my problem, so please help me with this?

       

      consider that my table is similar like below:

       

      Price_Table, YearMonth, amount

      Table1, 2016/12, 500

      Table2, 2017/05, 35

      Table2, 2017/08, 45

       

      I need to fill all missing months to each Price_Table till actual year/month

       

      So in the abovel example I expect this result:

      Table1, 2016/12, 500

      Table1, 2017/01, 500

      Table1, 2017/02, 500

      Table1, 2017/03, 500

      Table1, 2017/04, 500

      Table1, 2017/05, 500

      Table1, 2017/06, 500

      Table1, 2017/07, 500

      Table1, 2017/08, 500

      Table1, 2017/09, 500

      Table2, 2017/05, 35

      Table2, 2017/06, 35

      Table2, 2017/07, 35

      Table2, 2017/08, 45

      Table2, 2017/09, 45