In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors