Decimal numbers are wrong
Hi,
i have a CSV-file with decimal numbers, but they are loaded not correct by workbench:
"" --> correct mapped to null
"0.0392156862745098" --> correct mapped to 0.0392156862745098
"0.0784313725490196" --> correct mapped to 0.0784313725490196
"4.43137254901961" --> WRONG mapped to 443,137,254,901,961
It appears everytime if the number before the decimal is greater than zero. These numbers are all in the same collumn and are encapsuled with doublequotes(").
Thanks
Andreas
Comments
-
Hi Andreas
This isn't by chance a CSV that was saved from Excel, was it?
I had a similar problem a couple years ago and if I recall correctly, there was an issue with the scientific notation (ex 4.3Ewhatever) that Excel was using. I actually don't recall what the solution was, unfortunately, but maybe that gives you a starting point.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 746 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 68 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive