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!