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