Make new column

[amirrafique]

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

A	B	C
1313		1313
112		112
	21442	21442
1212		1212
	31213	31213
31313213		31313213

[BarnesK · Accepted solution]

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!