Rename field values in one column, insert them into a different column, and get a list view of both columns

[cmp_analyst]

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

[richgalloway]

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)