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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 689 Automate
- 177 Apps
- 454 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive