5 Replies Latest reply: Aug 25, 2015 11:24 AM by Razor Ramon RSS

    Remove unwanted rows in a table

      Hi,

       

      I have a straight table with content as shown below

       

           

      CID          LIDDescStartDateEndDate
      11Test30/06/201230/06/2013
      12Test231/10/201331/10/2014
      21Test30/11/200830/11/2013
      22Test231/07/201431/07/2015
      31Test29/02/200828/02/2013
      32Test231/10/201331/10/2014
      41Test31/08/201231/08/2013
      42Test231/08/201431/08/2015

       

      I would like to keep only one row for each CID, i.e the latest row of data.

       

      Can someone please let me know how to do this in the front end and not in the script?

       

       

      Thanks