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

      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?







      LOAD *

      RESIDENT Activity

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

      Drop Table Activity;