18 Replies Latest reply: Oct 10, 2014 4:06 AM by anbu cheliyan RSS

    Do not load record with null field

      How can i adjust my load script to ensure the recorded without an AccountId are NOT loaded

       

      Both these expressions kick up errors. What exactly am I doing wrong?

       

       

      WHERE NOT IsNull(AccountId);

       

      and

       

      WHERE len(trim(AccountId))>0;