rdomo Changed My Datatype
Hi,
I am trying to upload a data frame from R environment to Domo using ds_update. One challenge that I am facing is that somehow DOMO automatically changed one column into Date, from numeric.
Because the value in that column ranged from 0 to around 890 thousand, I guess DOMO thought they were numerical date… (like in Excel).
Now I cannot switch them back to numeric either, DOMO said it does not support such operations.
What can I do to ensure the type of data when I upload from R?
Thank you
Best Answer
-
rdomo doesn't support defining the dataset's schema when you upload it. It attempts to determine the schema automatically. With your numbers it fails the first two checks where it's looking for a specific date format however the third check attempts to conver the number to a date which succeeds so it assumes it's a date. You can search for "typeConversionText=function(data, colindex)" on
to see the actual R code.The Python pydomo package does support defining a schema manually so that your data will be uploaded with the correct types if you're willing to use Python:
Alternatively, you may be able to use a Magic ETL to change the data type with an Alter Column tile.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
rdomo doesn't support defining the dataset's schema when you upload it. It attempts to determine the schema automatically. With your numbers it fails the first two checks where it's looking for a specific date format however the third check attempts to conver the number to a date which succeeds so it assumes it's a date. You can search for "typeConversionText=function(data, colindex)" on
to see the actual R code.The Python pydomo package does support defining a schema manually so that your data will be uploaded with the correct types if you're willing to use Python:
Alternatively, you may be able to use a Magic ETL to change the data type with an Alter Column tile.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 562 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 583 Beast Mode
- 13 App Studio
- 28 Variables
- 585 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 359 Distribute
- 98 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Release Questions
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive