Decimal numbers are wrong
Hi,
i have a CSVfile 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
 10.6K All Categories
 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 251 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 62 Kowaza
 295 仲間に相談
 649 ひらめき共有