Import a google shared spreadsheet: a numeric column is changed to text?
Hi there,
When I import a google shared spreadsheet a numeric column is changed to text. To query with other databases the field type needs to remain numeric. Do you know how you can change a field type of a google shared spreadsheet?
Comments
-
Hi,
Did your format the Columns as a number in google sheets?
Do you have any value in the column (Other than the header) that is not numeric?
I have several googlesheet imports and the column types are correct.
Regards,
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Yes the columns are formatted correctly in googlesheets. I even tried creating new tabs and the format stayed as text.
0 -
Did you try and recreate the dataset in DOMO?
Regards.
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Not sure how to do that. Can you send me a few steps? Thanks very much!
0 -
In the Datacenter/datasets you have a delete option on the dataset.
Does this help?
Regards,
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 209 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 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
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive