6 Replies Latest reply: Sep 12, 2012 7:08 AM by Michael Tarallo RSS

    Getting the latest value

      Hi,

       

      Say I have the following data set

       

      ID           TransactionDate          Description

      1               3/1/2012                    FairBullet

      1               6/13/2012                  FairBullet with Arches

      1               6/30/2012                  Fair with Arches

      2               4/21/2012                  nails

      2               4/27/2012                  3' Nails

       

      What operator do I use and how do I setup the rule so that I would get the latest description for a particular ID? Example:

      ID           LastTransDate          Description

      1               6/30/2012               Fair with Arches

      2               4/27/2012               3' Nails

       

      I suppose I'm to use an Aggregate operator?