community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Error: Type mismatch in operator +

Alteryx
Alteryx
Created on

Question

I'm getting an error that says "Type mismatch in operator +" in my formula, what does it mean?

Answer

This error often means that you're trying to add a number to a string field. If you are trying to concatenate your fields, you need to be sure that all fields being combined are string values. When Alteryx sees a numeric value and a + operator it wants to add the values together as opposed to concatenate. 

 

There are (at least) two ways to resolve this error:

 

1) Use a Select Tool to change the field type before feeding the data into your Formula Tool

2) Use the ToString() function to convert the field to a String value within the expression itself

 

Both solutions are demonstrated within the attached v10.5 sample.

Attachments