We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

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

aries1295
6 - Meteoroid

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

7 REPLIES 7
Qiu
21 - Polaris
21 - Polaris

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

Capture124.PNG

aries1295
6 - Meteoroid
 

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

 

duda alteryx.png

Qiu
21 - Polaris
21 - Polaris

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

aries1295
6 - Meteoroid

duda alteryx.png

Qiu
21 - Polaris
21 - Polaris

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

 

Capture125.PNG

aries1295
6 - Meteoroid

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
21 - Polaris
21 - Polaris

@aries1295 
Everyone has its beginning time.

Glad to help.😁

Labels
Top Solution Authors