Error: Failed to parse data
Aloha All:
I have the error: Failed to parse data '43269' as type Datetime for column 'Entry Date'. When I pulled the data into Excel to look for the error, I could not find it. This error is on the raw data coming in from Workbench.
Any suggestions on how to fix this.
Mahalo.
SPM
Comments
-
Hi ... Can you clarify if the error is happening in Workbench prior to upload, or in Domo after the upload.
Thanks
Jared
@Hulachic5 wrote:Aloha All:
I have the error: Failed to parse data '43269' as type Datetime for column 'Entry Date'. When I pulled the data into Excel to look for the error, I could not find it. This error is on the raw data coming in from Workbench.
Any suggestions on how to fix this.
Mahalo.
SPM
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"1 -
Hi Jared:
It happened after the push from Workbench into Domo. The data type is set to datetime. I am unsure how to find and correct that data once it is in Domo; since the file appends.
Hope this helps.
SPM
1 -
Thanks for clarifying.
Basically what is happening is that Microsoft Excel encodes dates as the number of days from December 30, 1899 (not sure why they decided on that one).
So Excel is converting that serial number into a date for visualizing it in Excel, but Workbench is reading it as a number.
One way to get around it, is to change the datafield in workbench to integer. Then in a dataflow, add the following logic to convert it to a date:
select dateadd(d,`NUMBERFIELD`,'1899-12-30') as Date
That would add the number of days to Microsoft's starting data to the actual date.
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive