Update column title

[kauser]

Hello, 

how can i update column title into specific title "Account". every time i upload new data into my workflow will change the column title but one column need to consistent "Account". Based on example below i use dynamic select tool to pick column 2([FieldNumber=2]) and now need to change this title into "Account" 

Month 1 input data 

month	item	amount
1	a	10
2	b	20
3	c	24
4	d	56

Month 1 expected Output 

month	Account	amount
1	a	10
2	b	20
3	c	24
4	d	56

Month 2 input data 

Product	Series	amount
A1	AA	10
B1	BB	20
C1	CC	24
D1	DD	56

Month 1 expected Output 

Product	Account	amount
A1	AA	10
B1	BB	20
C1	CC	24
D1	DD	56

[caltang · Accepted solution]

This is a fun challenge! I have attached how I would do it.

If you want to maintain the data type, you can go further with the field info and also dynamic replace later on.

[binuacs]

@kauser another way of doing this

[OTrieger]

@kauser 
Another way will be to create a mapping file that indicate what is the source headers and the target headers. In this way you can have all the options in one place and then using one Dynamic Renaming tool will do the job.

That mapping file can be external file, that will give you even more flexibility to add new headers if in the future new versions will exist.

[Spainey]

@kauser This is similar to @caltang's answer, but removes a couple of tools and makes use of another function of the Dynamic Rename tool to "Take Field Names from Right Input Rows". You just have to specify the Old Field Name Column and the New Field Name Column and it works like a Find/Replace.