7 Replies Latest reply on Aug 2, 2016 9:06 AM by Carl Slifer

    How to filter for duplicate rows but keep the original record?

    James Brewerton

      Hello

       

      I have used the following function to remove duplicates in a data set:

       

      {  FIXED [Transaction Reference] : COUNT([Transaction Reference]) } = 1

       

      However in the example below it would completely remove rows 2+3. I would just like to remove row 3.

       

      Is there a method of doing this?

       

      Thanks

       

      James

       

      ControlValue Transaction Reference
      113.560540XAA299
      237.510540XAA303
      337.510540XAA303