Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

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

Combine two columns into one

skeen503979
8 - Asteroid

Hello!

Can someone please tell me how to combine two different columns into one?  I've got some data with two possible addresses.  There are no duplicates between address A or address B.  I just need a clean column that shows an address (whether it's A or B).  The addresses have numbers and letters which need to be preserved.  Did I input the formula correct below?  

 

If not, how can I do this?

 

skeen503979_0-1611691329043.png

 

skeen503979_2-1611691534985.png

 

 

 

 

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @skeen503979,

 

I have made two solutions for you but I believe the first one will suit your needs:

 

Emil_Kos_1-1611693358443.png

 

skeen503979
8 - Asteroid

Thanks @Emil_Kos.  The first solution (where you just add "+" instead of "and") worked great.

Thx!

Labels