Alteryx Designer Discussions

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

Combing two columns into one new column

Howland
6 - Meteoroid

I used to be able to use Concatenate in excel for this but I am very new to Alteryx and need to rebuild all my trackers in it like I had in excel.

 

Column A = ST90XS162

Column B = N

I want to concatenate these like this ST90XS162-N in column Z, I need the dash in there to cleary separate to two to help eliminate errors, would be nice to concatenate the headers too.

 

Please help

4 REPLIES 4
JordanB
Alteryx
Alteryx

Hi @Howland 

 

You can create a new field in the formula tool with this expression: [S:Cascade ID]+"-"+[C:Cand ID]

 

Best,

 

Jordan

Howland
6 - Meteoroid

Thank you sir, worked great!

ldixon001
5 - Atom

I used this in the formula: [CONTRACT_ID]+"-"+[CONTRACT_NAME];

 

however I get this error message:  Formula (66) The field "" is not contained in the record. (Expression #1)

 

Thank you.

ChrisTX
14 - Magnetar

Do you have a semicolon at the end of your formula?

Labels