"IS NOT LIKE" - Alteryx Version

[m0s00ws]

 Hi all,

below is a criteria I normal would use with 'Access'. As i try to shift over to Alteryx I am trying to find a similar function.

Basically, I need to filter out any data that starts with the below numbers; order is important. 

• Not Like "55*" And Not Like "66*" And Not Like "77*" And Not Like "88*"

I have tried using "Left(string,len)" and "findstring" to get a value and then filter out the desired results.

I thought the "left" tool would fix my problem but when I go to put in my category I get the following error (see attached). 

Any ideas on how I can fix this error or any other solutions? 

Thanks in advance,

MS

[MarqueeCrew · Accepted solution]

Left(ToString([po]),2) NOT In (‘55’,’66’,’77’,’88’)

The quote symbols may need replacement because my iPhone likes to challenge me.

[m0s00ws]

Much appreciated!

Cheers