Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

multi field rename

Krakan
6 - Meteoroid

Hi,

 

How can I rename many columns not manually, as per below:

 

Krakan_1-1666337918934.png

 

 

Thanks a lot.

2 REPLIES 2
DataNath
17 - Castor

Hey @Krakan, do you have the year in your data as well by any chance, or something else to distinguish between fields? Without something to differentiate, you won't be able to have multiple fields called the same i.e. 2 of each quarter and 2 fields named 'FY' as is the case in your example. Alteryx will automatically rename them like so:

 

DataNath_0-1666339590220.pngDataNath_1-1666339597297.png

 

Whereas, if you had the years (for example) involved, something like the following would work:

 

DataNath_2-1666339779219.pngDataNath_3-1666339791851.png

Emmanuel_G
13 - Pulsar

@Krakan 

 

Find in attachement the way of doing this mapping using the dynamic rename.

 

You can have a sample of new headers you want and replace simply by position.

 

Let me know if this solution works or not.

 

Emmanuel_G_0-1666342266561.png

 

Labels