Rename changing field headers

I have a workflow which determines the last three full months and displays parts usage by said months - the output looks something like this:

partID	2016_03_01	2016_04_01	2016_05_01
partX	92	78	66
partY	75	60	98

The dates will change every time the workflow is run in a new month.

I want to calculate the average for each part but as the dates are going to change how can I put this into a formula?

I don't need the dates so am quite happy if these can be renamed to something like Month 1, Month 2 and Month 3 and I can then use the formula tool as normal but I can't figure out how to do this. I've tried using dynamic rename but wasn't sure how to set it up.

Any help appreciated.

Dynamic Processing

Preparation

Accepted answers

Had a quick play.

I used a field info tool to get the field names out.

Then assigned a number to all but first column (RecordID)

Finally a dynamic rename to rename.

Sample attached

All comments

Had a quick play.

I used a field info tool to get the field names out.

Then assigned a number to all but first column (RecordID)

Finally a dynamic rename to rename.

Sample attached

Thanks James,

I'm away from the computer now but will definatly give this a try

Hi James,

Thanks, this works brilliantly, exactly what I needed Smiley Happy

I know this is three years after the fact, but this just helped me immensely! Thank you so much!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703