We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
9 - Comet

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

aatalai
15 - Aurora

@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
15 - Aurora

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

 

Labels
Top Solution Authors