DOMO Time Import Problems
I have an Excel data file with the following information:
Date of incident | Time of Incident
12/27/2017 | 01:00 PM
The literal value in the time field is "01:00 PM", verified by converting to .CSV and opening in text editor. However, when DOMO imports the time field, it correcly assigns it as a time data type, however it imports the value incorrectly. The above value of "01:00 PM" is converted to "2018-01-02 07:00:00". The date portion appears to be linked to when I import the data, but I cannot understand where/why the time portion is coming across incorrectly. Perhaps it's a time/zone conversion... Any help would be greatly appreciated.
Best Answer
-
Thanks @ST_-Superman-_. I'm using DOMO Workbench to pull in data from Excel and did not see anywhere that I could use SQL statements. But, your suggestion did point me to a Transforms section which has, ironically enough, a Shift Data Timezone Transform. Thanks, I will give this a shot and see what the results are.
1
Answers
-
My guess is that the data is coded in a different timezone. (UTC?)
You can adjust the timezone using this statement:
SELECT CONVERT_TIMEZONE('EST', `timestamp field`)
this should convert the timezone to EST time.
https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Time-Zones/m-p/21326#M2285
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Thanks @ST_-Superman-_. I'm using DOMO Workbench to pull in data from Excel and did not see anywhere that I could use SQL statements. But, your suggestion did point me to a Transforms section which has, ironically enough, a Shift Data Timezone Transform. Thanks, I will give this a shot and see what the results are.
1 -
The workbench tranformation worked perfectly, the times are now synced correctly. One more question though. How do I get the output to display just the time, and not the date time? The system is automatically appending the current upload date to the field, so for today's import I have '2018-01-04 13:00:00' when I just need to see '13:00:00'. I believe I can build a Beast Mode field to present just the time, but I'd rather do it natively if possible.
Also, under format I juat have Justification and Style (bold, italics, etc.).
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive