3 Replies Latest reply on Jul 13, 2016 7:43 AM by Luciano Vasconcelos

    How to select latest record

    Kian Hee Leow

      Hi,

      i have the following sample data

      IDModified DateContact
      A121/01/2016123456
      A221/01/2016456789
      A122/01/2016147890
      A323/01/2016111111
      A126/01/2016222222

      I am trying to explore doing the following

      1) create a latest_contact field such that the output is as follows

      IDModified DateContactLatest Contact
      A121/01/2016123456222222
      A221/01/2016456789456789
      A122/01/2016147890222222
      A323/01/2016111111111111
      A126/01/2016222222222222

       

      I ran out of ideas how this can be done and so need to advice of experts here

       

      Thanks in advance