5 Replies Latest reply: Jan 17, 2017 7:14 AM by Marcus Sommer RSS

    Question about Accumulate data with script

    Boonyasathe Ananphathana

      I have data something like columns below

         

      DateMachine No.TR-RPM
      01/01/2017MA0017436
      02/01/2017MA0017436
      03/01/2017MA0017436
      04/01/2017MA0017436
      05/01/2017MA0017436
      01/01/2017MA0027524
      02/01/2017MA0027524
      03/01/2017MA0027524
      04/01/2017MA0027524
      05/01/2017MA0027524
      01/01/2017MA0037656
      02/01/2017MA0037656
      03/01/2017MA0037656
      04/01/2017MA0037656
      05/01/2017MA0037656

       

      and the result that I need as column result.

          

      DateMachine No.TR-RPMresult
      01/01/2017MA00174367436
      02/01/2017MA001743614872
      03/01/2017MA001743622308
      04/01/2017MA001743629744
      05/01/2017MA001743637180
      01/01/2017MA002752444704
      02/01/2017MA002752452228
      03/01/2017MA002752459752
      04/01/2017MA002752467276
      05/01/2017MA002752474800
      01/01/2017MA003765682456

       

      So How to coding script for accumulate data with column TR-RPM ?

       

      Thank you.