1 Reply Latest reply on May 22, 2019 5:37 AM by Zhouyi Zhang

    Generating all the Dates between the changes

    gvkr g

      Hi Experts,

      help me with this scenario, The source table have lists of exchange rate values,However this table only contains the dates where the rate changed not the dates between the changes. Then I need to generate the dates between the changes as individual records and use the value from the previous date.

       

       

      Input Table:

       

      Date
      Rates
      01/01/20190.8
      04/01/20191.2
      07/01/20190.55
      10/01/20191

       

      Expected Result

      All Dates
      Rates
      01/01/20190.8
      01/02/20190.8
      03/31/20190.8
      04/01/20191.2
      04/02/20191.2
      06/31/20191.2
      07/01/20190.55
      07/02/20190.55
      07/31/20190.55
      10/01/20191