Transform Header description dynmaic

[Pascal_R]

Hi Community Team,

I get weekly sales data (for the past 26 weeks) in attached format with weeks header description.

I need to find a way to have the header changed for always the oldest week like "Sales WK1" etc--> see green headers.

In addition, I need to create a new column which just repeats the "sales weeks used" like: 34.2020-06.2021

+ a column with the Avr.Abs.Dev per line. 

Do you have any suggestion how do to that the most sufficient way?

Thank you very much for your support in advance.

BR,

Pascal

[mceleavey]

Hi @Pascal_R ,

In tried to make this as dynamic as possible:

(I've only done the first five, you can do the rest!)

Hope this helps.

M.

[Pascal_R]

@mceleavey 

Thank you very much for your solution.

How can you now tell that the first row are the "new" headers?

BR,

Pascal

[mceleavey]

Hi @Pascal_R ,

I'm sorry, I don't understand what you mean.

[Pascal_R]

@mceleavey 

How can I make now that the yellow row is the new header instead of 1,2,3,4 etc..?

[mceleavey · Accepted solution]

Ah, of course.

Just put a Dynamic Rename tool at the end and select "Take Field Names from First Row of Data":

M