convert string to whole number using magic etl
Hello,
I am trying to convert the datatype of a column to whole number which is having a string datatype using magic ETL and getting attached error. Source for the data load is from CSV file and i am loading data using workbench. Also tried changing the datatype in workbench which also could not complete the run.
And when tried converting using Magic ETL getting attached error.
Error : Failed to convert data ' ' to type integer for column "Name of the column"
Please help.
Best Regards
Bikash
Best Answer
-
you may need to first use the replace text action. Excel will often populate a ' ' instead of a null value. Use the replace text action to search for ' ' and then replace it with null. Then you should be able to change the data type
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Answers
-
you may need to first use the replace text action. Excel will often populate a ' ' instead of a null value. Use the replace text action to search for ' ' and then replace it with null. Then you should be able to change the data type
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Often the approach I take for this is to use Text Formatting to "Only show numbers" then do the Set Column Type. This insures anything that could be preventing the Set Column Type is removed.
3 -
Thank you for the solution it worked.
0 -
I even used Replace Text to replace any null or empty string with '0' before connecting to Text Formatting, making my dataset clean and reasy to read
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 542 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 344 Distribute
- 86 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive