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

[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.

[Qiu]

@aries1295 
Can you include some sample data in the snapshot?

[aries1295]

[Qiu · Accepted solution]

@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.

[aries1295]

Wow, I was looking at the wrong thing the whole time... I'm new to alteryx and this flux was designed by someone else, I was able to see what the error was and solved it in no time, Thank you for your observation!

[Qiu]

@aries1295 
Everyone has its beginning time.

Glad to help.😁