Either individually or using a mapping_table - the latter is perhaps more advisable as then you have a sure way of telling which is which and what were the original field_names - even without looking into the script (thinking of others who might not have a license)
I'm assumng that you do not want to rename fields, just trnslate values in filed [location], correct?
Create a mapping table from either an INLINE table (there aren't too many values to change) or from an external Excel/Text file with two columns that carry original value/translated value. The latter is more flexible as you can add more values to translate without changing your script. For example, this one can work:
MapTranslation:
MAPPING LOAD * INLINE [
Original, Trnslated
WADI, AL-WADI
ALN, AL AIN
DEIRA, DXB-DEIRA
DXB, DXB-IBN
MBZ, MUSSAFAH
AJN, AJMAN
SHJ, SHARJAH
RAS, RASALKAIMA
UML, UMMAIKOIN
];
Then use applymap() to perform the actual translations when loading the initial values for [location], like in:
LOAD
:
applymap('MapTranslation', [location]) AS [location]
Use ApplyMap. Create a doc file like excel with the names alon with the required name and call them in your table using ApplyMap function, to get the required names. You make check applyMap function in Help
.png "Luminary Alumni"){kind=icon}