How do I change a field that is a text to a number?

kim_barragan0126

I am trying to change a field that shows up as a text field to a number, but I am getting the below error in magic ETL. Any ideas on how to change this field to a number?

ColemenWilson

You can use a formula tile in magic ETL before your Alter Columns tile and use the below to remove the $. Then your alter columns tile should work:

david_cunningham

You would need to remove the $ if it is stored as text. You can do that with string functions. REPLACE() is probably your best bet.

ColemenWilson

You can use a formula tile in magic ETL before your Alter Columns tile and use the below to remove the $. Then your alter columns tile should work:

kim_barragan0126

thank you!