Header Rename/Dynamic Rename?

[J-Riedel]

HI,

After using the Cross Tab Tool, I need a way to rename some of the column headers, but the quirk here is that I will have new columns each month that I am hoping I can automatically have renamed (don't want to have to maintenance the process each month).

Here is my process:

Here is a sample of the Summarization that is then transposed So the 'ParmMon' becomes the header:

I would like a way to rename the "0", "1", etc. to "SharesM0", SharesM2", etc., and then for next month when month 7 is now added, I will need it to automatically update the "7" to "shares M7" and so on for each month.

Anyway of doing this?

Thanks!

Jan

[JagdeeshN · Accepted solution]

Hi @J-Riedel ,

Please find attached a sample workflow to showcase how you can possible implement this functionality.

Hope this helps.

Best,

Jagdeesh

[J-Riedel]

HI JagdeeshN

Thank you for the solution.  I was able to simplify it in my process, but your suggestion helped direct me to the answer.

I was able to just insert a Formula Tool in-between the Summarize and Cross Tab and use the formula "SharesM"+tostring([ParmMon]) to add a new column with the "SharesM#". 

Then in the Cross Tab, changed the Column Headers to the new Shares Month from my old ParmMon. 

End result:

Works like a charm!

Thank you!