community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Make new column

I want to create column C using existing columns A and B in file.

In excel I used IF formula to merge values from A and B.

How to do it in Alteryx designer

 

ABC
1313 1313
112 112
 2144221442
1212 1212
 3121331213
31313213 31313213

 

Pulsar
Pulsar

Hello @amirrafique 

 

One easy way to do this is with a Formula tool and the following expression:

trim(tostring([A]) + tostring([B]))

 

 

This expression accounts for the fact that your A and B fields may be numeric.

 

Hope this helps! 

Labels