Magic ETL error message
Best Answers
-
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.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
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.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Thanks Mark and Jae for answering, I will try it and will let you know.
1
Answers
-
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.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
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.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Thanks Mark and Jae for answering, I will try it and will let you know.
1 -
Thanks again Mark and Jay. I followed your advice and it work!
1
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 966 Connectors
- 254 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 75 SQL DataFlows
- 499 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 360 Beast Mode
- 19 Variables
- 481 Automate
- 101 Apps
- 376 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive