Parse error at char(): Formula: invalid type in subtraction operator

aries1295

Hi, I want to concatenate two columns, and I'm recievieng the following error:

Error: Formula (118): Parse Error at char(): Formula: invalid type in subtraction operator (Expression #3)

The formula that I´m using is: UPPERCASE([A] + "" +
[B])

Both A and B are V_String, just as the new column output is a V_String.

Any ideas on why is this happening? I have a select before the formula

Error Message

Accepted answers

Qiu

@aries1295
I think the issue is not with this formula since it states Expression#3.
You should have multiple Expressions in one Formula Tool.
Check the 3rd one.

All comments

Qiu

@aries1295
Can you re-check your data type by Select Tool?

Your formula is working fine in my test, so maybe the Data Type causes the problem.

aries1295

In the left image you can see that the select shows a V_String, and on the right shows the Formula.

duda alteryx.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703