Using a field list box to loop macro for each field

[Jay_Felton]

I have built a macro that utilises the inbuilt macro Test of Means and the Summarise tool to output statistics on each field selected. Currently, within the macro workflow I have duplicated the calculation 10 times and created a dropdown box for each instance. A better solution would be to have one instance of the calculation and run the analysis for each field selected within a list box. How would I best implement this?

I assume the solution would involve transposing the fields to rows and use a batch macro. However, I do not know how to do this such that the macro only requires 1 input and 1 output.

Macro Configuration and Output:

Macro Workflow:

[jamielaird · Accepted solution]

Hi @Jay_Felton 

It's hard to see exactly what's going on in your macro from the screenshots but using your description I've put together a conceptual view of how I think you might want to approach this.

The gist of it is that:

- your batch macro needs to process one field per run

- therefore the data needs to be transposed

- inside the macro, you can untranspose it to get back to the original data format

Let me know if that makes sense, and feel free to post up your workflow and macro if you'd like me to take a closer look.

Jamie

[Jay_Felton]

Hi @jamielarid

Thanks so much for the swift solution. This diagram makes it a lot easier for me to conceptualise how to make it work. I'll give it a shot and see how I go!