Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

how to form a NOT LIKE statement for Salesforce query

Highlighted
6 - Meteoroid

My where close works for something like this:

WHERE Field_Name__c LIKE '%substring%'

 

The problem is that I need this field to NOT contain the substring. I have not been able to make this work. 

 

Any help is appreciated.

Highlighted
11 - Bolide

Hi @jhouseslu 

 

Try this...

WHERE (NOT Field__c like '%Substring%')

Highlighted
6 - Meteoroid

Worked like a charm! Thank you!

Labels