Merge two dates

Reply
Highlighted
Yellow Belt

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

Projects.JPG

 

Thanks in advance

 

Accepted Solutions
Highlighted
Black Belt

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_Col...

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. 




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Highlighted
Black Belt

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Highlighted
Black Belt

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_Col...

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. 




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Highlighted
Black Belt

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.