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

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

Input

Optimization

Accepted answers

Jonathan-Sherman

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

All comments

Jonathan-Sherman

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 😉

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 🙂

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703