11 Replies Latest reply on Dec 1, 2020 1:04 AM by Robert Whelan

    Rolling data for the next twelve months

    Beeram Reddy New Member

      Hi,

      I have the requirement to load data into a table. I need to populate the latest recorded data for the next ensuing year. For Example if I have loaded data on 23-Aug-2020, I need to populate same(latest) data till 23-Jul-2021, only Date will change.

       

      For example:

       

      Date           Month_Id    Emp_Id                 Emp_Name            Pay_amount

      22-Aug-20   202008       1006459               John                             400

      23-Aug-20  202008        1004567               Kerry                            600

       

       

      Date             Month_Id   Emp_Id                 Emp_Name           Pay_amount

      24-Aug-20    202008     1004567                 Kerry                             600

      25-Aug-20    202008     1004567                 Kerry                             600

      ---------          ------           ------                         -----                               ---

      ---------          ------           ------                         -----                               ---

      ---------          ------           ------                         -----                               ---

      ---------          ------          ------                         -----                                ---

      ---------          ------          ------                         -----                                ---

      22-Jul-21    202107   1004567                   Kerry                                600

      23-Jul-21    202107   1004567                   Kerry                                600

       

      Any suugestions on how to acheive this?

       

       

      Thanks