5 Replies Latest reply: Sep 22, 2016 4:10 PM by Stefan Wühl RSS

    Removing duplicate records from the resident table using distinct clause

    Monica Chhabra

      Hi All,

       

      I am trying to remove all the duplicates and bring in only distinct rows from the resident table below but it still is bringing in all the duplicates.  See below I have Noconcatenate clause used too.  Any leads will be very much appreciated

       

      Thanks,

      Monica

       

      Table2:

      NoConcatenate

      Load

      Distinct *

      Resident Table1;

      Drop Table Table1;