Changing the "group by" variable in a macro

Question

Hi folks,

In the attached workflow, I am currently having to repeat part of the workflow to achieve my output.

For the Xtab1 and Xtab2 sections, is there a way to use a Macro to dynamically change the "group by" variable in the summarize tools, and dynamically updating the filter at the end of each section also?

Thanks!

BMRMacroQuery.yxzp

RSreeSurya · Answer

Hi,

yes, it is possible. This can be achieved by dynamically updating the XML of the Summarize, Transpose & Filter tools utilized in your workflow.