community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Fonction concatenate

Atom

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]

Atom

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

Labels