Dynamic Summarize

[Anvitha]

Hello,

I am trying to create a macro that will act as a dynamic summarize tool having two inputs; one for the data, other one for the configuration that can be dynamic. A sample for the configuration input is as follows:

Field	Action	Output Field Name
Field 1	GroupBy	Field 1
Field 2	Concatenate	Field 2
Amount 1	Sum	Sum_Amount 1
Amount 2	Sum	Sum_Amount 2
Amount 3	Sum	Sum_Amount 3
Amount 4	Sum	Sum_Amount 4

The fields and the action can be different for each time the workflow is running, so I want to create the macro that acts as a summarize tool according to the configuration provided. I guess we have to create a batch macro updating the xml inside a summarize tool. Could you please help me to create the required macro?

[FinnCharlton · Accepted solution]

Hey @Anvitha , here you go. Should work for all applications, you just need to make sure that the action is named exactly as it appears in the Summarize tool XML. For example, Concatenate is 'Concat', and Average is 'Avg'. Hope it's useful!

[Anvitha]

Hi @FinnCharlton ,

This works. thanks for the help :)