Update column title

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

Developer

Developer Tools

Accepted answers

caltang

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.

For Kauser.yxmd

All comments

caltang

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.

For Kauser.yxmd

binu_acs

@kauser another way of doing this

Dynamic_Select_29012025.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703