4 Replies Latest reply: Jan 17, 2018 3:33 AM by Marcus Sommer RSS

    How to flag Duplicate records in Script

    Rishi Minawala

      Emp_No.



       

      DateAmtDuplicate
      000011/1/20185.00
      000011/2/201810.00
      000011/1/20185.00X
      000024/2/20174.00
      000024/2/201720.00
      000033/1/20187.00X
      000033/1/20187.00

       

      Hi All

       

      I have the above data, I basically need to create another column that flags all the rows which are duplicates based on Emp_No., Date, Amt being the same for reporting purposes.

       

      I have tried various methods including the technique but this has a huge impact on load time.

       

      autonumber(Recno(), [Emp_No.] & '-' & [Date] & '-' & Amt) > 1 as Duplicate

       

       

      Any help would be much appreciated.

       

      Thanks