11 Replies Latest reply: Oct 3, 2016 6:56 AM by Massimo Grossi RSS

    Deduplicating by few fields and not 1 in the load script in data load editor

    Monica Chhabra

      Hi Experts,

       

      I have ~10 fields in my table and I have records that I want to dedup by 4 fields i.e Owner, Subject, Date and Account only.  Below is the syntax that I started to put together that gives me error.  Can someone help with the code?

       

      Thanks,

      Monica

       

      Unique_Activity:

      NoConcatenate

      LOAD *

      RESIDENT Activity

      Where Exists(Owner, Subject, [Date], [Account]);

      Drop Table Activity;