Is 'does not contain' the same as 'not like' in the SQL editor?

[Katie_K]

Hi folks, bit of a rookie question here, but I'm fairly new to using the SQL editor in Alteryx.

I am currently using a filter tool in a workflow and want to instead put that filter at the starting input tool via the SQL editor.

Is using 'not like' in the SQL editor the same thing as using a filter tool on the same field with 'does not contain'?

Thanks, Katie

[Jonathan-Sherman · Accepted solution]

Hi @Katie_K,

Yes I believe it would be, however you'll want to make sure to include percentage signs to convert it to be a wildcard contains search:

WHERE FieldName LIKE '%string%'

Would pick up where the FieldName contains string.

Kind regards,

Jonathan

[Sebastiaandb]

Hi @Katie_K ,

In SQL you probably want to use "VARIABLE not in ('1')' as in the Alteryx workflow filter you would use !=. 

So you're correct when stating they're different :-).

Hopefully this helps!

Greetings,

Seb 

[Sebastiaandb]

@Jonathan-Sherman **bleep** ACE members are always so fast haha 😉

[Jonathan-Sherman]

@Sebastiaandb we do try 😉

[Katie_K]

Thanks Jonathan!  Just tried it both ways now (with and without the wildcard signs) and I got the difference between the two ways that I was expecting... using the wildcard signs is the way to go.  You've made my day, cheers 🙂

[Katie_K]

Thanks Seb!!  Appreciate your response 🙂