Box Connector rounding excel values randomly
I'm trying to use the Box connector to do a straight-forward import of data from an excel file and have noticed that some values in fields formatted as numbers are being randomly rounded to two decimal places. Once the data ends up in domo the field data type is correct, but the actual stored value becomes #.##000000000. I tried running the excel file through a workbench job instead and all of the values came through as expected without any rounding.
Comments
-
@MalcolmChaney you realize they are rounded when you're previewing the data inside of Box? Is that where the rounding is occurring?
You mention "once the data ends up in domo the field data type is correct" does that mean the problem does not exist in Domo and just the preview in Box?
Sorry for all the questions, I'm just trying to figure out where the problem is. I'm not sure if you want the value to be ##.####### or ##.## and if either of those where there is a mismatch from the originating file.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有