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

Options

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?

Best Answer

  • ColemenWilson
    Answer ✓
    Options

    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:


    If I solved your problem, please select "yes" above

Answers

  • david_cunningham
    Options

    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.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • ColemenWilson
    Answer ✓
    Options

    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:


    If I solved your problem, please select "yes" above

  • kim_barragan0126
    Options

    thank you!