Skip to content

    • Magic ETL

    Magic ETL

    Failed to convert value '(137.790)' from type string to type floating point

    Member
    in Magic ETL

    Any idea how to fix this error? It seems that my columns are a floating point, so not sure what the fix needs to be.

    image.png

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      You could use string functions to remove unwanted characters with formulas like

      1. CAST(REPLACE(REPLACE(`YourColumn`, '(', ''), ')', '') AS DECIMAL)

      ** Was this post helpful? Click Agree or Like below. **
      ** Did this solve your problem? Accept it as a solution! **

    Answers

    • Coach

      @kim_barragan0126 It looks like the parenthesis around the value are preventing it from converting to a floating decimal. You will have to remove those characters before converting the datatype using a formula. Do you know if the parenthesis represent a negative number, like in an accounting format?

    • Member

      Yes, it represents a negative number. Would the below fix this in the magic etl?

      Using a string operation.

      image.png
    • Coach

      @kim_barragan0126 Yes, that would work!

    • Coach
      Answer ✓

      You could use string functions to remove unwanted characters with formulas like

      1. CAST(REPLACE(REPLACE(`YourColumn`, '(', ''), ')', '') AS DECIMAL)

      ** Was this post helpful? Click Agree or Like below. **
      ** Did this solve your problem? Accept it as a solution! **

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories