Do not load blanks

[#1]

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 ;

[martynlloyd]

Hi Alex,

Just to point out that Null and Blank are not the same thing...

Did Hendric's solution work?

[johnca]

Hi Alex,

The syntax for not equal to in Salesforce is != so your where clause should contain

Where Subject != Null

--john

[hic]

Not quite...

The "NOT IN" operator is a SQL operator that doesn't work in a Load, so you need to replace that with a Match:

     not Match(Type, 'Email','Call','RM/ Bloomberg Chat','Minor communication')

When that is done, it should work.

HIC

[#5]

Thanks again Henric.

Your help is greatly appreciated.

[#6]

yes