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.

Error in a statement

VeronicaElse
8 - Asteroid

Can I use the error in a statement for multiple created columns in Formula tool?

 

If [MCO Name] in ('BDD') then Null() else "error in a" endif

 

I want to do this to multiple columns to output these nulls in a separate output as a monthly quality check

 

It let me do this for the first column then the next ones it says its a malformed statement which makes me think maybe you can only use this for one column in the formula

 

thanks!

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

Hi, we are going to need to see an image of your configuration pane here I think, it will certainly help us get to the root of the issue quicker.

 

Ben 

VeronicaElse
8 - Asteroid

should I do a formula or filter to make sure each column only has a specific item? Also, can I filter it out incase the wrong item is in the column as an audit piece?

 

and what do you need me to show you?

Labels