Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Make new column

Highlighted
5 - Atom

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

 

Highlighted
14 - Magnetar
14 - Magnetar

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