Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
15 - Aurora

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

Labels