Issues with changing cast dataset to date
Best Answer
-
During the append, the matching fields being appended default to the most compatible data type between the appends sources. So if you change one source to Date, but the other is Date Time, it will change the data type to Date Time. You'll need to ensure that the data type for all inputs to your append are cast to Date. Add an Alter Columns tile here:
Alternatively, you could cast to date after the append.
If I solved your problem, please select "yes" above
1
Answers
-
During the append, the matching fields being appended default to the most compatible data type between the appends sources. So if you change one source to Date, but the other is Date Time, it will change the data type to Date Time. You'll need to ensure that the data type for all inputs to your append are cast to Date. Add an Alter Columns tile here:
Alternatively, you could cast to date after the append.
If I solved your problem, please select "yes" above
1
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 95 Manage
- 92 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive