Free Trial

Alteryx Designer Desktop Discussions

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

Turn number filed and Vstring fiield to vstring

CherylH
8 - Asteroid

Beginner question here.

 

How to do I turn a field coming in as "double" to a string?

 

Need to concatenate double string & vstring to a vstring.

 

 

Here is my formula, billing # is the double and brand is vstring.  think I need a to text or something before the double.

[BP Billing #]+[CMA Brand]

1 REPLY 1
ggruccio
ACE Emeritus
ACE Emeritus

Hi @CherylH ,

 

Use a select tool to change the number to a string prior to attempting your formula.  There are other ways to program it within the formula tool, but this may be easiest.

 

ggruccio_0-1613756346824.png

 

Labels
Top Solution Authors