9 Replies Latest reply: Apr 21, 2014 5:08 AM by Rahul Lakhina RSS

    Loop through multiple fields to get Peek Value

    Rahul Lakhina

      Hi,

       

      I have a table with multiple variables that are set at different times. Please see excel attached. What I want to be able to do is capture that last value of the variable for all subsequent time. For example: Field 1 was set to 'true' at 2013-12-16 06:58:57 for all 17 entries after that I want Field 1 to have 'true' as the value and for Field 2 which was set at 2013-12-16 06:59:58 all previous records would be blank and all blank records should take the peek value. I could use previous however it would mean having to rewrite the statement many times as I have close to 100 variables. Could someone please suggest a solution?  Regards Rahul