Error Message

[chilby]

Hello! 

New Alteryx user here with a question:

I am trying to write a formula that will analyze all my subscription IDs for Null or Non-null and if any of them return a unique 18 digit ID, I want the row's formula to state "Sub Found" and if all sub ID columns are null, then return "None Found" however it looks as if I am getting a syntax error. 

the metadata for all sub IDs is Vstring. 

Please help, thank ya!

chilby

[Luke_C · Accepted solution]

Hi @chilby 

Remove all of the 'IF's other than the first row and it should work. IF initiates an if statement, it does not need to initiate each clause the if statement is evaluating. 

[Jonathan-Sherman]

Hi @chilby,

I'd take a slightly different approach to your formula rather than having so many AND statements, but both would work!

IF
MAX(
[Field1],
[Field2],
[Field3]
	) = Null()
THEN 'None Found'
ELSE 'Sub Found'
ENDIF

Checking what the max value is within your fields, if the max is Null we can determine all fields = null.

I've attached my workflow for you to download if needed.

Kind regards,

Jonathan

[chilby]

Thank you very much @Luke_C

[apathetichell]

Quick FYI - another reason your initial formula was generating that error was that your last clause before endif was ELSEIF.

ELSEIF requires a THEN and finally an ELSE.

Had you used ELSE instead of ELSEIF your original may have worked.