If/and/then statement with parce error char(0)

[Kumasan77]

Hello,

I'm pretty new to Alteryx and I'm not quite sure what i'm doing wrong here.

All the reference columns are data type V-string and I want my output to be a string as well. All the other posts I viewed this error was due to the data type not being formatted as a number/float, but I'm only working with strings here and would like to return a string, so I'm not sure if I need to use an entirely different formula or not.

What I would like to see is "if the RepName column contains test and the Client name column contains test then the In/Out column should return out, else return In"

[MarqueeCrew · Accepted solution]

@Kumasan77 ,

At some point in time, you created a 2nd expression in your formula tool.  Alteryx allows you to make many expressions.  You're on your way to learning.  The 2nd expression is "collapsed".  If you press the > button, you'll expand it.  But also, off to the right is a 🗑 trash icon.  You can DELETE the 2nd formula expression.  Once you do that, you'll be running.

Cheers,

Mark

[Kumasan77]

That did the trick. Thanks!

[MarqueeCrew]

@Kumasan77 ,

You're welcome.  

BTW, you can use the 📷 camera icon when posting to make the picture appear easily in the post (example below).  

Cheers,

Mark