amount field type importing as Text
ANyone know why when i select a data source with an Amount Column, Domo is recognizing it as Text rather than Amounts? How can i correc this?
Comments
-
where does the data originates from before making it into Domo ?
from a sql view uploading through wrokbench ?
from an excel spreadsheet store in your machine or in box or other uploading it into Domo using a connector ? etc
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 -
an excel file on a server
0 -
if you can , go into the excel and make sure that all values in the columns showing amounts has nothing other than numeric values... what happends is that usually the excel is updated by a person and if someone enters a text value by error in one cell , it makes the whole column a text column.
it could be a comma , a space or anyother value what is turning the whole column into text.
make the correction, save and re-run the load into Domo.
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 -
I don't see anything other than values in the column
0 -
Can you run a formula on your excel for that column ... =ISNUMBER(yourcolumncell) and drag it down til the last record, see if any returns false
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 -
I did that and there are no False
0 -
Gosh ? i'm running out of ideas.
is the column generated from a formula in the excel ?
last thing to do is to create a data flow in Domo , magic etl , bring the input dataset and from the edit column menu use the set column type option to force the column to display as number instead of text in Domo.
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 -
No, just contains numbers
0 -
You can put it through a dataflow and cast to number.
1
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 296 仲間に相談
- 649 ひらめき共有