16 Replies Latest reply: Jun 1, 2015 8:43 AM by Sasidhar Parupudi RSS

    Flagging Duplicates

    Dermot mcgoldrick

      I can easily enough find what records are duplicated :

       

      if (peek('Line_ID',-1) = Line_ID ,'Dup','NoDup') as DupRec

       

      But this will only mark the 2nd record, I need to mark the first one as well, ie mark them both as duplicate?