Rename field names with other rows

[oliviercz]

Hello, my input data is this :

and I would like to rename the field with the concatenation the first row and the field names (and keeping only the year from the field name note the number afterward)

So my desired output would be this :

 

Thanks

[pdave87 · Accepted solution]

hi, 

@oliviercz yes, this can be achieved by following below steps. Tested workflow is attached for your review.

[AngelosPachis · Accepted solution]

Hi @oliviercz ,

Here's one way you can do it. You should first isolate the first record of data, that contains your month names. Then if you transpose that record, you can form you column headers as YYYY + Month. Then with a dynamic rename tool, you can rename each column in your dataset

Hope that helps, let me know if you have any question on the workflow.

Cheers,

Angelos