In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

dynamic rename - remove prefix

BosKev
8 - Asteroid

Hi All,

 

simple question: I use the dynamic rename tool to remove a prefix front of multiple fields but I want to add a fixed text in front like Plan or Actual. how can I do that? Thanks.

 

BosKev_0-1581610164982.png

 

3 REPLIES 3
BosKev
8 - Asteroid

OK , I found a dumb way by adding another dynamic rename after to add prefix. if there a simpler way?

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @BosKev,

 

If you're using a dynamic rename to remove the prefix from multiple fields can you not use two more to add plan and actual prefixes? Or you could transpose and do a find and replace against a lookup table of adjusted column headers?

 

Regards,

Jonathan

BosKev
8 - Asteroid

Thanks, I thought there might be a formula that can do the trick with one tool instead of 2 duplicating tools. 

Labels
Top Solution Authors