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
Solved! Go to Solution.
@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.
In the left image you can see that the select shows a V_String, and on the right shows the Formula.
@aries1295
Can you include some sample data in the snapshot?
@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.
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!
@aries1295
Everyone has its beginning time.
Glad to help.😁