Alteryx Designer Desktop Discussions

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

Filter (Custom Filter)

wbroughton
7 - Meteor

Hello All! I'm creating a custom filter that is connected to an Excel sheet.  Once I create the filter and run the workflow, I receive an error message, that "Parse Error at Char(65): An operator must be between operands. " If you look at the attached screenshots, I believe I have operators included, but not sure to pinpoint why it's not working properly. 

 

Does anyone have suggestions on how I can resolve this? I would greatly appreciate the help!

4 REPLIES 4
Swathi
8 - Asteroid

do try giving a space after '0' <space> AND 

aatalai
13 - Pulsar

@wbroughton are the other (the fields in black) are they string or number format? If number then you do not need quotes and that might be causing an issue

wbroughton
7 - Meteor

@aatalai I literally figured it out a few minutes after posting this, and you are right! Appreciate it!

aatalai
13 - Pulsar

cool @wbroughton can you mark that as the solution then please?

 

Labels