Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

An Expression cannot end with an operator.

jeremywai
7 - Meteor

What is wrong with my filter?  I kept getting the error "an expression cannot end with an operator."

 

Left([Account], 3) <> "149" AND

Left([Account], 4) <> "1499"

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @jeremywai 

 

<> is not accepted in alteryx. != is not symbol recognized by Alteryx

 

Left([Account], 3) != "149" AND

Left([Account], 4) != "1499"

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

atcodedog05
22 - Nova
22 - Nova

Hi @jeremywai 

 

Here is an example

atcodedog05_0-1602174868328.png

Workflow:

atcodedog05_1-1602174886617.png

 

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

 

jeremywai
7 - Meteor

Thank you.  Should have thought of it.

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @jeremywai 

 

Cheers and happy analyzing 😀

 

Dont forget to mark the post as solution if it works

Labels