Correcting date format in Magic ETL
Hi all,
First time posting here. I need to know how to correct date formatting within a dataset. The dataset was pulled from Google sheets. As you can see, in ETL the formatting is wrong and inconsistent. How can I correct the format in ETL and make everything streamlined and compatible in the analyzer? Thanks
Answers
-
I would first try using the formula tile in Magic ETL and wrap the DATE() function around your field. Domo will convert them to the same format and make your field a date field which you can then use in Analyzer.
DATE(`Start Date`)
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
When looking at your data set what data types does it show for those two fields?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi,
The image in the original post is from the dataset
0 -
Hi, are you recommending to implement a beastmode in the ETL? Is that possible?
0 -
You can use the formula tile in the new magic ETL version to apply the DATE function. Alternatively you can use Alter Columns to change the data type of your columns to Dates
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@jhester yes, the formula tile in magic ETL gives you beast mode functionality within the ETL. You can overwrite existing columns or create new columns. You can find the formula tile under the utility section on the left side.
I have created a video that walks you through using the tile that you may want to watch.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive