11 Replies Latest reply: Oct 29, 2014 8:33 AM by anbu cheliyan RSS

    get max date from qvd

      Hi,

      I want to pull from  QVD only the max date of each product.

      How can I do that? see example below.

       

      Raw Data:

      PART  PRICE    DATE

      a          10          01/01/2014

      a          20          01/01/2015

      b          10          01/01/2015

       

      Output:

      a          20          01/01/2015

      b          10          01/01/2015

       

      Thanks to all,

      Jacob