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
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 27 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 86 Community Announcements
- 4.8K Archive