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

Using the in database tool, how can you convert a v_string into a double?

jthompson789
8 - Asteroid

Is there a way to convert a v_string data type into a double using the in database tool. 

I did find some help with writing a SQL script but my SQL skill are very limited and could not figure out the proper syntax.

 

2 REPLIES 2
Dynamomo
11 - Bolide

if you use the in-db formula tool, you can create a new field with the double type and then enter this in the SQL expression area

cast("TheFieldYouWantToConvert" as float)

Then use the select tool to remove the old string field and rename the new field to replace it

 

jthompson789
8 - Asteroid

Thank you for the suggestion it worked great.

 

Labels