Magic ETL error message

Liliana
Liliana βšͺ️

Hello, can someone help me figure out how to fix this error in my ETL

"failed to convert data '$0.00' to type BigNumber for column 'Gross charge'


Thank you.

Best Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀
    Accepted Answer

    It would be helpful to see the convert statement that you are using and more clarification as to which ETL tool you are using in Domo (Magic ETL, MySQL, Redshift, etc.)

    If I had to guess, your this Gross charge column is of type text. You can use the REPLACE function to remove the $ from your data and then try to convert it to a numeric data type after that. You might also need to use the REPLACE function remove any commas that are in your values as that can get in the way as well.

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀
    Accepted Answer

    @Liliana

    the error is exactly what it says on the tin.


    failed to convert data '$0.00' to type BigNumber for column 'Gross charge'


    you can't convert $0.00 int a number because of the $

    you have to remove the $ from your data before you try to convert it into a number.

  • Liliana
    Liliana βšͺ️
    Accepted Answer

    Thanks Mark and Jae for answering, I will try it and will let you know.

Answers

  • Liliana
    Liliana βšͺ️

    Thanks again Mark and Jay. I followed your advice and it work!