8 Replies Latest reply: Aug 23, 2013 2:46 AM by Ashwani Kumar RSS

    Returning only the most recent transaction associated with an ID

      Hello,

       

      I have a transaction log with a column containing IDs and a column containing dates. What is the most efficient way to return the most recent date for each ID (along with the other columns in the table of course). I believe I should be using firstsortedvalue() but I'm unclear on how exactly to use it and how it works.

       

      right now my script looks like:

       

      Table:

      LOAD ID as %ID,

           Date as Date,

           Info as Info

      From

      [C:\etc. . .]

      (qvd);

       

      Thanks