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.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 460 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 188 Visualize
- 251 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive