3 Replies Latest reply: Apr 21, 2017 9:42 AM by Marco Madini RSS

    Extract data record from max date

    Marco Madini

      Hello,

      please someone can help me?

      I want to extract from a file:

      for any material code the last data, qty and price from a lot of movement.

       

         

      materialdataqtaPrice
      a17/01/2017110
      a18/01/2017211
      a19/01/2017312
      a20/01/2017413
      a21/01/2017514
      b21/02/2017520
      b22/02/2017421
      b23/02/2017322
      b24/02/2017223
      b25/02/2017124
      c17/03/2017130
      c18/03/2017231
      c19/03/2017332
      c20/03/2017433
      c21/03/2017534
      Result
      a21/01/2017514
      b25/02/2017124
      c21/03/2017534

       

       

      tks in advance.

      Marco