3 Replies Latest reply: Feb 21, 2018 7:29 AM by Thiago Justen Teixeira RSS

    In a row: set min as zero; set difference to following values

    Saiyed Hamid Mahmood

      Hi,

       

      in a sorted (ascending) field I have values in seconds. In my load I want to set the minimum value of that field to zero. The following values should then be represented by the difference to the preceding value. Example:

       

      I have:

       

      Time
      12
      13
      15
      17
      18

       

      I want a new field Duration based on Time-Field:

       

      Duration
      0
      1
      2
      2
      1

       

      How to calculate this during load?

       

      Thanks,

      Hamid