Alteryx Designer Desktop Discussions

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

What is wrong in this IF formula

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

1 REPLY 1

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,

IF Formula