3 Replies Latest reply: Jun 19, 2017 10:17 PM by Louis Lam RSS

    Create yearmonth record for each id

    Louis Lam

      Hi all

       

      I have a table below:

      IdYear-Month
      1201601
      2201604
      3201611
      4201703

       

      I would like to generate the table below:

      Header 1Header 2
      1
      201601
      1
      201602
      1
      201603
      1
      201604
      1
      201605
      1
      201606
      1
      201607
      1
      201608
      1
      201609
      1
      201610
      1
      201611
      1
      201612
      1
      201701
      1
      201702
      1
      201703
      1
      201704
      1201705

       

       

      Other Record also generate until today year month.

       

       

      Best Regards,

      Louis