Start Free Trial

Alteryx Designer Desktop Discussions

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

Combining Columns or Formatting Data

nwatzlaf2319
6 - Meteoroid

Hello,

 

I am looking to combine columns into one single output field. There are dashes I need to include as well. I feel like I am overcomplicating it but the desired output is in the format below.

 

--Building-Aisle-Bay--

 

Thank you for your time,

Natalia

3 REPLIES 3
binu_acs
21 - Polaris

@nwatzlaf2319 one way of doing this

image.png

nwatzlaf2319
6 - Meteoroid

Thank you for your time @binu_acs but that does not give me the desired output. I will keep trying.

 

The desired output should read --G-42-299--

 

nwatzlaf2319
6 - Meteoroid

I figured it out. I used a formula to bring the fields together. I forgot that I could simply use a + to combine string fields in a formula. 

 

Labels
Top Solution Authors