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"
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 😀👍
Hi @jeremywai
Here is an example
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Thank you. Should have thought of it.
Happy to help 🙂 @jeremywai
Cheers and happy analyzing 😀
Dont forget to mark the post as solution if it works