STRING formatting with a decimal
Hello -- I've created a dataset with a column definition as:
"type" : "STRING",
"name" : "SKU"
However when I load the data, the "11465730" as "11465730.0". I see that the column is a text field. Why is Domo formatting it with ".0"?
Here's a link to the dataset:
https://citrusad.domo.com/datasources/54c1369b-d98d-4fbe-950d-99456ad328cc/details/data/table
Comments
-
What is the value that is being sent up to Domo? How are you generating your data value? Is it possible that when it's being generated before it's sent to Domo that it's getting the .0 added?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
No, it's just an integer. There is no formatting of the data when we send it into Domo.
0 -
Sounds like Dom is storing it as a non-integer data type (DOUBLE or DECIMAL) so there's not much you can do on the way in. What you could do is run it through an ETL and use the Alter Columns tile to change the datatype to a LONG / Integer to remove the .0 at the end of the values. Alternatively you could set the data type on the input data source tile's configuration tab itself.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I would think that's pretty much what I do. I'm creating the dataset via the API, specifying the column datatype. It seems like a bug to me.
0 -
If all your SKUs are actually all numbers, could you specify the type to be integer in your API? Perhaps that would keep Domo from adding the decimals.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive