2 Replies Latest reply: May 15, 2014 10:00 AM by Chickenman _ RSS

    Help select/filter rows

    Chickenman _

      :confused: There may be an easy way to do this, but I sure don't see it!

       

      I have a simple text report with over a million records. I can model to get the fields I want to a table with no problem but I want only the rows with the first instance of each item i.e.[/I] the most recent date. An abbreviated sample:

       

      ITEM                 DATE     

      38001700             7/2/2007 

      38001700             6/29/2006

      38001704             3/29/2005

      38001704             1/3/2005 

      38001704             11/10/2004

      38001704             10/27/2004

      38001716             3/2/2007 

      38001716             2/15/2007

      38001716             1/18/2007

      38001730             12/21/2006

      38001730             9/22/2006

      38001730             8/31/2006

      38001768             11/17/2005

      38001768             4/8/2005  /code

       

      Any suggestions for an approach would be appreciated.

       

      Regards,

      CM