7 Replies Latest reply: May 15, 2014 10:10 AM by Olly Bond RSS

    Filter out all duplicate records, keep only unique records

    pth3x _

      I am trying to make a filter that will remove all duplicated records and keep only unique records.

      For instance, in the following table

       

       

      Therapist     Rx Date                     Patient     Treatment     

      COOKE     2/2/2011 13:00     TAYLOR     PT EVAL       

      COOKE     2/2/2011 13:00     TAYLOR     PT EVAL       

      BARRET     2/2/2011 8:30     PHIPPS     THERAPEUTIC ACTIVITY 15 MIN       

      KELLY     2/2/2011 9:00     MAREK     PT EXERCISE THERAPY 15 MIN       

      KELLY     2/2/2011 9:00     MAREK     PT EXERCISE THERAPY 15 MIN     

       

      I want the filter to return only

       

       

      Therapist     Rx Date                    Patient     Treatment       

      BARRET     2/2/2011 8:30     PHIPPS     THERAPEUTIC ACTIVITY 15 MIN     

       

      I can't find this searching the forum.

      If anyone can help, I would be very grateful.

      Thank you,

      patrick