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

Options
kim_barragan0126
kim_barragan0126 Member
in Magic ETL

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?

image.png

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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:

    Screenshot 2024-06-28 at 11.09.55 AM.png

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

Answers

  • david_cunningham
    david_cunningham Coach

    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
    ColemenWilson Coach
    Answer ✓

    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:

    Screenshot 2024-06-28 at 11.09.55 AM.png

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

  • kim_barragan0126
    kim_barragan0126 Member

    thank you!

Categories