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

Alteryx designer Discussions

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

New column combining string and double

Meteoroid

Hi we are trying to create a new field what will output a combination of text & the value in a numeric field.

Example:

 

New field:

"Record ID -" + [Record ID#]

 

you would see  Record ID - 12345

 

The only way we can figure out to do this (and not receive a data type error), is to change the [Record ID#] data to string to have this work.

We do not want to change the data type and then change it back.

 

Is there not an easier way?

 

Highlighted
Bolide

@nogap2,

 

I think you are looking for the ToString Function in the formula tool. Something like:

 

New field:

"Record ID - " + ToString([Record ID#], 0)

 

Best,

MSalvage

 

Alteryx Certified Partner

You need to turn the number into a string if you are going to concatenate it with a string but you can do this on the fly.  Use the ToString() function

"RecordID -"+tostring([Record ID#]

 

Labels