Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Fonction concatenate


Hello, i am a new user and i want to know the name of the function to concatenate columns.

Thank you in advance.

Alteryx Certified Partner

Hi @Khaa 


The simplest way is to use the formula tool and do something like [Field_1]+" "+[Field2]


the fiels i want to concatenate are a mix of numbers and characters, so using the operator "+" is not possible i think

Alteryx Certified Partner

You can use the toString([Field1]) or toNumber([Field1]) to convert the types