how to change the type of existing DOMO data?

Lu_zhang · 2024-04-25T09:34:02+00:00

There was an error rendering this rich post.

Lu_zhang

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

Find more posts tagged with

Accepted answers

ArborRose

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.

All comments

ColemenWilson

You can use the following beastmode to correct the date:

date_add(date('1899-12-31'), interval floor(あなたの日付フィールド) day)

ArborRose

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.

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/95277#Comment_95277

@ArborRose where is the toolkit function for Schema Management? thanks,

ArborRose

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/95330#Comment_95330

thank you. I am asking my DOMO administrator to update my user.

@ArborRose

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.