how to change the type of existing DOMO data?

Lu_zhang
Lu_zhang Member
in Cards, Dashboards, Stories

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

image.png

Best Answer

  • ArborRose
    ArborRose Coach
    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.

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ColemenWilson
    ColemenWilson Coach

    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

  • ArborRose
    ArborRose Coach

    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! **

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

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

  • ArborRose
    ArborRose Coach
    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.

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Lu_zhang
    Lu_zhang Member
    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:

    1. how to distinguish data from different date? In DOMO, by appending data, it will accumulate each day's data without DATE distinguished.
    2. how to append data with the smallest manual workload?

    What is your opinion on above?

    Thank you.

Categories