"IS NOT LIKE" - Alteryx Version

m0s00ws — Thu, 24 May 2018 04:45:59 GMT

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.

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,

Re: "IS NOT LIKE" - Alteryx Version

MarqueeCrew — Tue, 23 Jan 2018 03:34:09 GMT

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

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

m0s00ws — Tue, 23 Jan 2018 03:53:19 GMT

Much appreciated!

Cheers