11 Replies Latest reply on Aug 9, 2018 9:46 AM by meenu choudhary

    Removing Duplicates based on a condition

    Bishar Sethna

      Prior to creating visualizations I need to remove duplicate id records in my database based on a condition. I have read about LOD's being used but cannot figure out how to write the syntax. I am hoping for some help.

       

       

      In the image I have 4 ids 1863, 4266, 4402, and 7795 which show up as duplicates. The only record I need to eliminate from my visualizations will be the one associated with Id# 4266 as this person has applied for the same term. Furthermore the record which I need eliminated is the record associated with the earliest decision date, in this case August 2, 2017. Any help will be appreciated.

       

      Best,

      Bishar