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

Alteryx Knowledge Base

Definitive answers from Designer experts.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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