Question on changing field/data type

[mullinexm]

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!

[michael_treadwell · Accepted solution]

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.