Combing two columns into one new column

[Howland]

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

[JordanB · Accepted solution]

Hi @Howland 

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

Best,

Jordan

[Howland · Accepted solution]

Thank you sir, worked great!

[ldixon001]

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]

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