4 Replies Latest reply: Jun 17, 2015 12:03 PM by Jaswant Chowdary RSS

    Apply Input Field value to forward records untill new Input Field value

    Jaswant Chowdary

      Hi All,

       

      I have use case where i want to input value and carry the same value until new input value entered.

       

      Can some body advice me how to do this with Rangesum function or any other functions like above()

       

      Input Data

      INPUTFIELD PriceInput;

       

      LOAD * INLINE [

          PERIODID,     Price    ,PriceInput

          201501,      10        ,0

          201502,     15        ,0

          201503,     20        ,0

          201504,        10        ,0

          201505,        30        ,0

          201506,        25        ,0

      ];

       

      Desired O/P:

       

      PERIODIDPricePriceInputNewPrice
      201501101515
      20150215015
      20150320015
      201504101010
      20150530010
      20150625010

       

      In the above example if i enter value 15 at PriceInput at Period 201501 then it should carry forward untill new value 10 entered at 201504.

       

      and same 10 has to carry forward all the way upto new value entered.

       

      Thanks