Rename Title for unpredictable title

[kauser]

Hello, 

i do have a workflow and there is a column which title will change every time we update workflow with new weekly/monthly data. how can i rename that new title into specific title " New Accounts".  for example- 

Month 1 input data - 

Item

4568

Month 2 input data - 

Quality

2459

Output we expected for Month 1  

Month- 1

New Accounts

4568

Output we expected for Month 2 

Month- 2

New Accounts

2459

[alexnajm · Accepted solution]

What logic is available to decide which field gets renamed to "New Accounts"? If there is no logical way to find which one to rename (column position, keyword, etc.) then I am not sure we have a solution

[kauser]

yes there is a logic i will use to pick that column and that can be ([FieldNumber] = 2)

[alexnajm]

perfect - just like the other thread!

[kauser]

mistakenly clicked on solution 

[alexnajm]

Ok - it’s still the same solution where you can use a Dynamic Select to get the correct field (in this case ([FieldNumber] = 2) - the only difference is now you can also put down a dynamic rename to take that field and rename it via the formula option. The main thing to call out is to make sure that dynamic or unknown fields remains selected in that dynamic rename tool so that if the name changes, the renaming still happens

[kauser]

can you please provide what should be in formula option. Thanks 

[alexnajm]

"New Accounts"

[kauser]

Can you please provide the formula that i can use into formula on dynamic rename tool 

[alexnajm]

"New Accounts" is the formula........ you are selecting one column in the Dynamic Select using ([FieldNumber] = 2) so you are simply overwriting the remaining field's name with "New Accounts"