2 Replies Latest reply: Aug 1, 2014 10:18 AM by Marcus Malinow RSS

    Previous Row Value in Script

      Dear all,

       

           kindly below my input and require output

       

      Table Input

       

      LocationItemLineIDDaysReqAvailable
      XXXABCLine146132
      XXXABCLine240132
      YYYABCLine35516
      YYYABCLine44316
      YYYABCLine54016
      YYYABCLine63416
      YYYABCLine72316
      YYYABCLine8516
      YYYABCLine9316

       

      Output shoul be like than:

       

       

      LocationItemLineIDDaysReqAvailableoutput
      XXXABCLine14613231
      XXXABCLine24013230
      YYYABCLine355165
      YYYABCLine443164
      YYYABCLine540163
      YYYABCLine634162
      YYYABCLine723161
      YYYABCLine85160
      YYYABCLine9316-1