Macro for Multi Field Formula

Question

Hi all,

I am hoping someone can help me with the following -

I have a case whereby I am testing multiple string fields to check what the length is, if the field is not empty or is in Upper case. I am trying to develop a macro which will accept the various field using a select tool but the length of the field in the multi field formula expression is an input parameter from the macro.

I am fairly new to macro and I am not too sure how to do this - I have included an attempt to it as attached but I do not think this is the correct way. Could anyone please help?

Macro_Multi_field.yxmc

jamielaird · Accepted Answer

Hi @YanishDewan

I think you're on the right track.

I made a couple of improvements to your workflow as follows:

* Since the multi-field formula tool tests all fields, there doesn't seem to be any reason to have field mapping enabled on the macro input
* To avoid the 'pass' or 'fail' value overwriting the original value being tested I modified the multi-field formula tool to add a new column prefixed with 'Result_'

See attached (I've included some dummy data) and if this isn't giving you the result you are after let us know what needs to be different.

Cheers,

Jamie