Control Parameters with summarize and dynamic rename

[messi007]

Dear Alteryx Community,

My case is about to do a dynamic summarize using a batch Macro.

The target is to let the user select the column to use for the group by and then continue the process.

I have done the attached Macro and workflow.

I managed to batch in the group by but not in the column even The group by is done in a different column it's still with the same name that I used to build the macro.

I tried the dynamic rename but it doesn't work.

Many thanks in advance 🙂

[AkimasaKajitani · Accepted solution]

I may not understand your intensions.

Your workflow output is below.

Is the below output is your needs?

Field name "Category" rename into "SubCAT".

I edit below.

 

If it doesn't fit your needs, let me know.