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!
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
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?