Alteryx designer Discussions

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

If and function help needed

Highlighted
Asteroid

Here is my worksheet, and I want have a formula like below:

If [receiving date] is not empty and [Arriving date] is empty, then [Arriving date] = [receiving date]

I don't see the IF AND function in the formula tool, so how to solve this problem...

Thank you.

 

UPCArriving dateReceiving Date
66092121030 12/28/2017
66092121146 1/5/2018
66092121191 1/5/2018
6609212124512/1/2017 
6609212129012/1/2017 
6609212134412/1/2017 
660921213412/1/201712/1/2017
Bolide

Hi @ll1100000

 

I think your issue may be the last part of your IF function.

 

Try bringing in a formula tool and setting the field to be 'arriving date'. That way, any output will be placed into this column. Our expression is then:

 

IF !IsEmpty([Receiving Date]) AND IsEmpty([Arriving date])
THEN [Receiving Date]
ELSE [Arriving date]
ENDIF
Labels