Change column data type
I have a column with a date as a string, example 01/01/21. I want to convert to a date. I attempted using string to date and date format in Magic ETL 2.0, but I got an error message saying that it couldn't parse the text field to date. Then I tried the alter column tile, which also threw an error. I turned off Magic ETL 2.0 and tried the set column type tile, which worked. Is the alter column in 2.0 different from set column type? Does anyone know what I need to do in 2.0 to get this to work?
Best Answer
-
Hi @dacorson
Magic ETL 2.0 doesn't know if your format is MM/DD/YY, DD/MM/YY, YY/MM/DD... etc by default. You need to explicitly define your format using a format string within the Alter Columns tile for your field. To do this you need to click the gear icon, then select the Date Settings option. In here you'll need to select "Custom Format" for Date & Time settings then define the format of your date string.
%m = Month
%d = Day
%y = 2 digit year
In this example I assumed Month/Day/Year:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Hi @dacorson
Magic ETL 2.0 doesn't know if your format is MM/DD/YY, DD/MM/YY, YY/MM/DD... etc by default. You need to explicitly define your format using a format string within the Alter Columns tile for your field. To do this you need to click the gear icon, then select the Date Settings option. In here you'll need to select "Custom Format" for Date & Time settings then define the format of your date string.
%m = Month
%d = Day
%y = 2 digit year
In this example I assumed Month/Day/Year:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive