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.

Filter (7) Parse Error at char(10): Unknown variable "Corp. Code"

achapman
5 - Atom

Error:   Filter (7) Parse Error at char(10): Unknown variable "Corp. Code"

 

I know this is a simple fix, but I can't figure it out.  Here is my formula:

 

Contains([Corp. Code],"usa")

 

HELP! Please! 🙂

3 REPLIES 3
Luke_C
17 - Castor

Are you sure that the field name is "Corp. Code", or that the field wasnt inadvertently removed from the dataset upstream? The error indicates that the field is not present.

achapman
5 - Atom

Thank you!  I realized the "start data on import line" was off.  Doh!

Qiu
20 - Arcturus
20 - Arcturus

@achapman 
As suggested by @Luke_C ,kindly check your field name.

Actually you can pick the Column Name from the formula tool as below

Formula.png

Labels