How to make a dynamic workflow?

[digvijayp_]

Hi Community,

I am trying to do summary calculations on say set of 5 columns as of now but I want to add the feature where even if more, say 8-9 columns are present , the workflow should work correctly.

My wild guess is that this can be achieved using macro but I haven't explored that bit much.

Just wanna get your opinion on how to do it? and if there is any other way to achieve this?

[Jonathan-Sherman · Accepted solution]

Hi @digvijayp_,

This sounds like a multi field formula tool - allowing you to apply a formula to more than one column at a time. Selecting the "unknown" placeholder field will also mean new columns that come in will also be affected by the multi field formula so you may want to take a look into using that too.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[DavidP]

In order to create a summary such as a sum or average of multiple fields, I would transpose the fields, create a group identifier for the fields you're looking to summarize , then use a Summarize tool set to group on your group identifier and sum or average within the group and use Crosstab to revert to the original format.

There are built in Column and Row Total functions in the CrossTab tool as well.

An example data set would help if you have one or if you can mock something up.