Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Reason for error

AbdulBasit
8 - Asteroid

Parse error at char(10): Type mismatch in operator +

 

Can any one tell me what is the reason behind this error.

1 because its trying to combine 2 fields with different data type. This is what is coming to my mind.

 

1 REPLY 1
Elias_Nordlinder
11 - Bolide

Hello @AbdulBasit,

 

This is correct.

This error comes up when trying to combine two datatypes that are not compatible,

for example trying to add a string and int datatype together.

 

Look at this solution for more information 🙂

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Type-mismatch-in-operator/ta-...

I have added a quick workflow I created to show some solutions as well.

(I would not use the ToString function for adding two numbers together, as in my example

45 + 23 becomes 4523, and not 68. In this case either change both types to int in either the select tool

or use the ToNumber function is better, as they are then adding up like normal then.)

 

Elias_Nordlinder_0-1629629826536.png

 

 

//Regards

Elias

Labels
Top Solution Authors