Alteryx Designer Desktop Discussions

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

Several columns add into one column

Surname
7 - Meteor

Hi there, 

 

I have one question to data blending: 

 

My Data Source is Salesforce. I chose one Table and three Fields: 

1.PNG

 

And this is my Results as an output: 

2.PNG

 

I have three colums (becaus of three fields). 

My question is how can I assemble all three colums into one column?  

 

Thank you in advance!

DS

1 REPLY 1
AndrewW
11 - Bolide

You can use a Formula tool to create a new Output Field and concatenate the values. The expression would be (assuming the fields are all string): Code1+Code2+Code3.

Labels