Multiple fields rename at once

Question

hi

i need to rename multiple fields how can i do so without renaming one by one

example

old field:

field

new field:

field_id

old field:

function

new field:

function_id

and so on..

so i need to rename each old field with new field .

and i have 400+ old fields how can i do without renaming one by one

DataNath · Answer

Hey @SahilArora3139, are you just adding ‘_id’ to all of these?

I’d recommend checking out the Dynamic Rename tool. One of the options you can select is to rename any fields that you select (can choose all), with a certain formula you enter so you could just use something like [FieldName] + ‘_id’ for example and that’d be applied to every single one you tick. Quick example of before and after:

Dynamic rename 400+ fields.yxmd

SahilArora3139 · Answer

The main expression to add is ‘ _’ so each 400 fields i just need to add or remove ‘_’