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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

New column combining string and double

Meteor

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?

 

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