Creating a label from a numeric value

[#1]

For specific data I need to translate a number to a label. I have been using an if() function like

if(MANAGER1=5304, 'End Users',
if(MANAGER1 =5569, 'IBM',
if(MANAGER1=5349, 'HP',
'All Others')))

In the example above I am simply summing the revenue by manager, but was to provide a label instead of the manager number used by the system. I was wondering if there was an easier way as this can get pretty long and difficult to manage.

[rwunderlich · Accepted solution]

Use a MAPPING LOAD with either an applyMap() or MAP USING statement. See the Reference Guide section on Mapping.

-Rob

[#3]

Thanks Rob! I just happened to run across the blog entry after I added the post.