Error in a statement

Question

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!

VeronicaElse · Answer

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?

BenMoss · Answer

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