5 Replies Latest reply: Jan 10, 2017 3:08 AM by annick whitfield RSS

    Filter a table based on the first chronological event

    annick whitfield

      Hello,

       

      I have the following table:

       

      EventTable:
      Load * inline
      [
      ID1,    ID2, ID3,  Action,    EventDateTime
      10,      1,    99,    Create,    '12/30/2016 11:02'
      10,      1,    99,    Update,     '12/30/2016 11:03'
      10,     1,     99,   Delete,     '13/30/2016 11:02'
      10,      1,    98,   Delete,    '12/30/2016 14:02'
      10,      1,    98,   Update,   '12/30/2016 12:02'
      10,      2,    99,   Update,   '13/30/2016 13:02'
      10,      2,    99,   Update,   '13/30/2016 15:02'
      10,      2,    99,   Update,   '12/30/2016 08:02'
      ];

       

      I would like to keep only one line for a given ID1/ID2/ID3 item i.e. the one with the Min (EventDateTime)

      10,      1,    99,   Create,    '12/30/2016 11:02'

      10,      1,    98,   Update,   '12/30/2016 12:02'

      10,      2,    99,   Update,   '12/30/2016 08:02'

       

      I would very much appreciate your help!

      Thanks

       

      Annick