Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

srea541
8 - Asteroid

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!

 
3 REPLIES 3
caltang
17 - Castor
17 - Castor

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? 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

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

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
apathetichell
19 - Altair

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

Labels