Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Merge 2 columns with date data

Laure
5 - Atom

Hi,

 

I'm trying to merge 2 columns (Offer Accepted Date and Offer Declined Date) included dates into only one as below (Offer Decided Date)

 

Person IDOffer Accepted DateOffer Declined DateOffer decided date
120-Feb-17 20-Feb-17
2 30-Mar-1730-Mar-17
3 30-Mar-1730-Mar-17
4 27-Feb-1727-Feb-17
503-Apr-17 03-Apr-17
6   
723-Mar-17 23-Mar-17

I tried to use formula if or transpose with no success. Any idea what can be the right process?

 

thanks a lot

 

2 REPLIES 2
patrick_digan
17 - Castor
17 - Castor

@Laure Does this formula work for Offer Decided Date:

Max([Offer Accepted Date],[Offer Declined Date])

Let me know if something about your data doesn't work with that formula. You can also use If statements trying to find null/empty values, but the Max formula is a nice shortcut sometimes.

Laure
5 - Atom

Hi Patrick,

Thanks a lot, it works perfectly well!

 

 

Labels