I used "Eval Case" to replace the values similar to this. We ended up using a lookup table, since there were 70 possible values and the query was thus very long.
Here's a snippet of my code that you could adapt. In my case, I wanted to add the more verbose value. So PEGA0001 was replaced with the longer version after the comma. The 1=1, "Google It.." at the end is a catch all, for any value not defined in the case string.
|eval PegaAlertV=case(PegaAlert="PEGA0001","PEGA0001-HTTP interaction time exceeds limit",
PegaAlert="PEGA0002","PEGA0002-Commit operation time exceeds limit",
PegaAlert="PEGA0003","PEGA0003-Rollback operation time exceeds limit",
PegaAlert="PEGA0004","PEGA0004-Quantity of data received by database query exceeds limit",
PegaAlert="PEGA0056","PEGA0056-Defragmentation of the table associated with class System-Locks takes too long",
1=1,"Google It..")
-JD
... View more