Several columns add into one column

Question

Hi there,

I have one question to data blending:

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

And this is my Results as an output:

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

AndrewW · Accepted Answer

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.