how to change the type of existing DOMO data?
data has been uploaded into DOMO.
the first column is in integer type like '45319' but actually it is DATE(Jan-28-2024),
how can i change it to DATE in DOMO without changing the original spreadsheet data type?
thanks
Best Answer
-
Admin » Governance » Toolkit » Schema Management
Schema Management lets you change the column type (data structure) of a dataset. If your dataset has an integer as the data type for a field, you can change it to a date.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
You can use the following beastmode to correct the date:
date_add(date('1899-12-31'), interval floor(あなたの日付フィールド) day)
If I solved your problem, please select "yes" above
1 -
Colemen's answer converts the information to date. There is a toolkit function for Schema Management to modify structure for that date. Please mark Colemen's answer as yes if it solves your issue.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@ArborRose where is the toolkit function for Schema Management? thanks,
0 -
Admin » Governance » Toolkit » Schema Management
Schema Management lets you change the column type (data structure) of a dataset. If your dataset has an integer as the data type for a field, you can change it to a date.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
thank you. I am asking my DOMO administrator to update my user.
3PL send me daily storage data, in the file, each sheet reflects that day's data, for example, sheet '4.26' reflect 26th April data, sheet '4.25' reflects 25th April data. those sheets are accumulated in one file called 'month to date' storage report with each day's data in different sheet.
I'd like to connect this daily data file with a DOMO designed card to automatically append data to the card.
I have two difficulties:
- how to distinguish data from different date? In DOMO, by appending data, it will accumulate each day's data without DATE distinguished.
- how to append data with the smallest manual workload?
What is your opinion on above?
Thank you.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 601 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 689 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive