Merge two dates

Khan

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

 

MarkSnodgrass

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.