community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

IF Formula

What is wrong in this IF formula

 

IF ([Related Instrument],"") THEN [Instrument No] ELSE [Related Instrument] ENDIF

 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @amirrafique 

 

You don't have a logic statement

Use IsEmpty function. It returrns TRUE or FALSE

 

IF IsEmpty([Related Instrument]) THEN [Instrument No] ELSE [Related Instrument] ENDIF

 

Cheers,

Labels