SOLVED
dynamic rename - remove prefix
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BosKev
8 - Asteroid
‎02-13-2020
08:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Dynamic Processing
- Help
3 REPLIES 3
‎02-13-2020
08:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
OK , I found a dumb way by adding another dynamic rename after to add prefix. if there a simpler way?
15 - Aurora
‎02-13-2020
08:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎02-13-2020
08:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, I thought there might be a formula that can do the trick with one tool instead of 2 duplicating tools.
