Alteryx Designer Desktop Discussions

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

Error - Multi Column Formula

AlteryxUserFL
11 - Bolide

I'm trying to look through every cell and check if it equals "-" or is null/empty. If so, I want to update it to state "NO Column Name Data". Anyone know what is wrong with my expression? 

 

DrewDavis_0-1589997845907.png

 

1 REPLY 1
Hannah_Lissaman
11 - Bolide

Hi @AlteryxUserFL 

 

Looks like you are missing a closing ) after your IsEmpty function

 

You will also need to get rid of the second line of code (where it says THEN t ELSE f ENDIF)

 

The rest looks good

Labels