I would like to rename the field values that exist in one column and add them into their own separate column while keeping the original column (with the values before they were renamed) to show how they map to the new values in the new column.
The idea is if I have a list of IDs (original) that I want to map to different names in a separate column that represent those original IDS (basically Aliases) but want to keep both of the columns in a list view, how would I go about doing that?
Example: Display
Original IDs | NewIDs |
P1D | Popcorn |
B4D | Banana |
O5D | Opp |
If you need to preserve the original field then you aren't renaming. Use the eval function to create a new field based on the old one.
| eval NewIDs = case(OriginalIDs="P1D", "Popcorn",
OriginalIDs="B4D", "Banana",
OriginalIDs="O5D", "Opp",
1==1, OriginalIDs)