Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
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
Top Solution Authors