Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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