Dynamic change a macro's fieldnames

[jensroy]

Hi,

I have a macro that i want to be used for multipurpose "Share of anything" (share of visits, share of business ...). Right now i have an input that goes into a macro. Here i must match the right fields:

I would like the output to Say "Store", "Orders" and "Share of Orders". And if the metric changes to be visits, then i would like the output to say "Store", "Visits" and Share of visits".

Attached is the workflow and the macro if anyone could share some insights on how to solve this.

[gc]

What if you did something like this after your Formula tool and before the macro output? Would that work?

[StephenR]

You can use the dynamic rename tool to change the field names.  The problem is that the macro input renames the fields so that they flows properly within the macro.  This means that field names are static within the macro.  To get around this you will need another text input to give the rename value to the dynamic rename.

Also, the macro was saved as an iterative macro, but it should be set as standard for this workflow. 

[patrick_digan · Accepted solution]

@jensroy Here was my technique:

1) Use an action tool from the macro input to your select to get back your original field names. I only came across this recently and it's very powerful.

2) Change the macro to a standard macro as @StephenR pointed out.

3) Use the sample tool to grab the first row, transpose it, and then use the multi row formula to get the calculated field to be shares of <<your second field name>>

4) Use the dynamic rename to rename your shares of field.

Hope that helps! Your workflow should now be working as expected.