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

Question on changing field/data type

mullinexm
5 - Atom

Hi. I have a problem changing the field type from string value to numeric ($000.00)  field but every time I change it from v_string to any other data type in the ‘SelectTool’ the field changes to ‘null’ (data file is text/csv). I’m trying to make it so that the sign amount and payment amount in my data set are numeric that way when I export the findings to Tableau it will be a measurable value. Any help is greatly appreciated. Thanks!

1 REPLY 1
michael_treadwell
ACE Emeritus
ACE Emeritus

To change '$000.00' from string to numeric you must remove the '$' character. I've attached a module as an example.

 

Once you export to Tableau you can set the Default Number Format to Currency in the data window.

Labels