Dynamically Updating the "Group by" field in a summarize tool - using a batch macro

[srea541]

Hi,

I am trying to create a Batch Macro that will dynamically update the group by variable - it is currently looping through the different variables that I wish to group by, but the renaming element of the macro is not working properly.

"Territory select" comes through as the first "group by" column as expected, but the "industry select" element just gets joined onto the bottom of this - I need the industry select groupings to have their own column (and in these cases - territory select would be null).

I have attached the Alteryx package below if anyone is able to point me in the right direction?

Thanks!

[caltang]

I had this question sometime ago.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Summarize-with-Interfa...

I solved it using BenMoss' macro and made some changes of my own. Maybe it can give you some ideas? 

[caltang]

Something related as well: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Summarise-Error-No-fie... 

[apathetichell]

go to interface designer and select auto-configure by Name.