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

Hi @J-Riedel ,

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

Hope this helps.

Best,

Jagdeesh

sample.yxmd