14 Replies Latest reply: Jul 15, 2014 8:49 AM by Alex Hamilton McLeod RSS

    Do not load blanks

      I’m trying to ensure rows where the Subject field are blank in my data, are not loaded. However, I’ve tried the following terms but they all throw up scripting errors

       

      where not IsNull(Subject) ;


      where Len(Trim(Subject))>0 ;


      Where Subject is not null ;