dynamic rename - remove prefix

[BosKev]

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]

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

[Jonathan-Sherman · Accepted solution]

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]

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