8 Replies Latest reply: Jun 2, 2017 1:44 AM by Devarasu R RSS

    Rename the data values of a field

    Aishwarya R

      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