0 Replies Latest reply: Oct 18, 2018 3:18 AM by Ruma Barman RSS

    Incorporating all dates as line item in the main table:

    Ruma Barman

      Hi All,

       

      There is a table where data is there along some dates of the month.I want all dates from starting of the fiscal year till date to be associated along the key of the table.

       

       

      Like if the table is

      Key Date            Rate

      1     31/08/2018   11

      2     30/04/2018   22

      3     30/06/2018   33

       

       

      Output should be

       

       

      Key Date            Rate

      1    30/04/2018  

      1    31/05/2018

      1    30/06/2018

      1    31/07/2018

      1    31/08/2018   11

      1    30/09/2018

      1    31/10/2018

      2    30/04/2018   22

      2    31/05/2018

      2    30/06/2018

      2    31/07/2018

      2    31/08/2018

      2    30/09/2018

      2    31/10/2018

      3    30/04/2018  

      3    31/05/2018

      3    30/06/2018  33

      3    31/07/2018

      3    31/08/2018

      3    30/09/2018

      3    31/10/2018

       

      How to achieve this?