Combing two columns into one new column

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

Alteryx Examples.xlsx

Join

Accepted answers

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

Best,

Jordan

Thank you sir, worked great!

All comments

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

Best,

Jordan

Thank you sir, worked great!

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.

Quick Links

Tags

This months top contributors