Converting data from categories to values
Comments
-
I think Domo is reading your numeric fields as String. Unfortunately, if you're uploading an excel file directly into Domo (without using Workbench) you can't control the field types.
I recommend using Workbench to upload data into Domo as it gives you lot more control over your data (you can set the data type for each field) and it's more robust.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Another alternative to the statement above is to use the ETL Magic Flow. I think the workbench would be a quicker solution still.
0 -
@Dhoeppner, did any of the replies above help answer your question?
0 -
It may be prudent to double check the data in your Excel file. I had a similar issue once, and it turned out that due to a copy/paste error a couple of rows had text rather than numbers.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive