Merge two dates
Hi,
Is it possible to merge two different date fields into one?
I want to merge the Project_startdate and Project_upgradedate as one field. Below is an example:
Project_startDate | Project_upgradedate | Projects |
10/14/2020 | 10/14/2020 | 34 |
10/15/2020 | 10/20/2020 | 50 |
10/16/2020 | 60 | |
10/17/2020 | 50 | |
10/18/2020 | 50 | |
10/19/2020 | 50 |
Thanks in advance
Best Answers
-
Yes. You can do this in Magic ETL or in a beast mode. You would use the Set Column Value tile in the ETL. Here's a link to how to use it: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/04ETL_Actions%3A_Edit_Data#Set_Column_Value
In a Beast Mode, you would use the IFNULL function like this:
IFNULL('Project_upgradedate','Project_startdate')
This would use the project_upgradedate field if it is there. Otherwise, it would use the project_startdate field.
**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 -
If you have Magic 1.0 you split your data into 2 parts. Where where Col B is NULL and Col B IS NOT NULL (use FILTER tiles) then you can use SET COLUMN tile or I use SELECT and just choose the column I want to keep.
If you're on the Magic 2.0 beta you can use a Formula tile and use IFNULL as Mark recommended.In MySQL you can use a COALESCE function.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
Yes. You can do this in Magic ETL or in a beast mode. You would use the Set Column Value tile in the ETL. Here's a link to how to use it: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/04ETL_Actions%3A_Edit_Data#Set_Column_Value
In a Beast Mode, you would use the IFNULL function like this:
IFNULL('Project_upgradedate','Project_startdate')
This would use the project_upgradedate field if it is there. Otherwise, it would use the project_startdate field.
**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 -
If you have Magic 1.0 you split your data into 2 parts. Where where Col B is NULL and Col B IS NOT NULL (use FILTER tiles) then you can use SET COLUMN tile or I use SELECT and just choose the column I want to keep.
If you're on the Magic 2.0 beta you can use a Formula tile and use IFNULL as Mark recommended.In MySQL you can use a COALESCE function.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive