Rename the data values of a field

[Anonymous]

Hi everyone,

Is it possible to rename the data values that is being pulled from database?

For instance,

NatureOfWork:

LOAD

    NatureOfWorkID,

    NatureOfWork

FROM [lib://Master/NatureOfWork.qvd]

(qvd);

The NatureOfWork field contains values as 'Cots', 'Application Development', 'Analytics'

Now I want to change 'Application Development' to 'AppDev'.

Thanks

[Rahul_Athavale]

Hi,
Yes you can change it.
if(Wildmatch(NatureOfWork,'Application Development'),'AppDev') as NatureOfWork