Rename Title for unpredictable title

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

Developer

Developer Tools

Accepted answers

alexnajm

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

All comments

alexnajm

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"

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335