Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ;
Hi Alex,
Just to point out that Null and Blank are not the same thing...
Did Hendric's solution work?
Hi Alex,
The syntax for not equal to in Salesforce is != so your where clause should contain
Where Subject != Null
--john
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
Thanks again Henric.
Your help is greatly appreciated.
yes