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
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive