Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Multiple fields rename at once

SahilArora3139
8 - Asteroid

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

2 REPLIES 2
SahilArora3139
8 - Asteroid

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

DataNath
17 - Castor

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:

 

DataNath_0-1678376874051.pngDataNath_1-1678376881896.png

Labels