Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Type mismatch in operator +

BillyL14
8 - Asteroid

Hi

What does this error mean?

WL1_2-1594306871306.png

Any advise on how to fix? Am just adding a zero to the front of 7 digit codes.

Had no issue with this similar function below.

WL1_1-1594306854176.png

thanks

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

Hi @BillyL14 

 

It would seem that [Code number2] is a numeric-type field. To use the value of this field as a string (so it can be combined with other strings) you can apply a conversion to the value in the formula. You could add the ToString( function to the field reference like this: ToString([Code number2]) and the expression will be valid.

 

However, if the field is numeric, and even if you make the expression work, the resulting string will not be able to go back into the numeric field. You could assign this expression to a new field, change the field type of [Code number2] ahead of time, or use a Multi Field Formula tool to apply the expression and change the field type in one tool. 

BillyL14
8 - Asteroid

thanks

Labels