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

    Returning only the most recent transaction associated with an ID



      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:



      LOAD ID as %ID,

           Date as Date,

           Info as Info


      [C:\etc. . .]