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