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

New column combining string and double

nogap2
7 - 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?

 

2 REPLIES 2
MSalvage
11 - 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

 

Dynamomo
11 - Bolide

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