Failed to run dataset due to error from the bery beginning node
I have a dataset that failed to run due to an error from the very beginning node. It said "Failed to convert value '5785586.012810127' from type 'String' to type 'Date'."
However, that input itself runs normally and the data looks legit. I checked, no abnormal and no value of 5785586 anywhere.
I tried to change all timestamp to date but it still faces the error.
Can you please advise on how to fix this? Thanks!
Best Answer
-
If you click on the configuration for your input dataset you can then expand the Data Handling menu, there will be one or more columns with a data type of Date, change them to Text. Then in your ETL you can handle any conversion issues downstream.
1
Answers
-
If you click on the configuration for your input dataset you can then expand the Data Handling menu, there will be one or more columns with a data type of Date, change them to Text. Then in your ETL you can handle any conversion issues downstream.
1 -
Thanks so much! That helps big time.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 653 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 795 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive