Populating a new field from 4 cells in a priority order

MCicc

Hey all.

This is my first time posting on the Alteryx boards so pardon me if this is the wrong area to be posting this.

I'm working to develop a workflow that populates a field based off of the content of 4 other fields in a specific priority order.

Context: I have 4 metadata fields (DateCreated, DateLastMod, DateRcvd and DateSent) and I need them to populate the LeadDate field in a specific order.

I need the following to happen.

1. Create a LeadDate field

2. Where LeadDate is blank, LeadDate = DateSent

3. Where LeadDate is blank, LeadDate = DateRcvd

4. Where LeadDate is blank, LeadDate = DateLastMod

5. Where LeadDate is blank, LeadDate = DateCreated

6. Where LeadDate is blank, LeadDate = "00/00/0000"

I just started really using Alteryx so don't destroy me on my approach. I'm sure I'm doing this wrong but gotta start somewhere. I created the LeadDate field and made it equal to DateSent in the first Formula. In the second Formula I have the following:

IF IsEmpty([LeadDate]) THEN [DateRcvd]
ELSEIF IsEmpty([LeadDate]) THEN [DateLastMod]
ELSEIF IsEmpty([LeadDate]) THEN [DateCreated]
ELSE "00/00/0000"
ENDIF

What am I doing wrong here?

Thanks in advance,

Mike

MarqueeCrew

hi @MCicc ,

 here is my take:

if you have a lead date, keep it otherwise look for another date. 

IF !IsEmpty([LeadDate]) THEN [LeadDate] ELSEIF

!IsEmpty([DateSent]) THEN [DateSent] ELSEIF

!IsEmpty([DateRcvd]) THEN [DateRcvd] ELSEIF !IsEmpty([DateLastMod]) THEN [DateLastMod] ELSEIF !IsEmpty([DateCreated]) THEN [DateCreated]
ELSE

"00/00/0000"

EndIf

mike, this field must be string. 

cheers,

 mark