3 Replies Latest reply: Apr 1, 2013 4:00 AM by Selvakumar S RSS

    Apply Map with inline

      Hi All,

       

      For all other hardcoded value below in inline table, i should display as Functional Staff for all Designation.

       

      I tried this code but somewhere it's wrong. Kindly help!

       

      FunctionalROLE:

      mapping LOAD * INLINE [

        DESIGNATION,FUNCTIONAL_ROLE

        S01,Functional Manager

        S02,Functional Manager

        S03,Functional Manager

        S04,Functional Manager

        S05,Functional Staff

        S06,Functional Staff

        S07,Functional Staff

        S08,Functional Manager

      ];

       

      LOAD Distinct DESIGNATION,

           ApplyMap('FunctionalROLE',DESIGNATION,'Functional Staff')

           FROM

      [..\01_QvdGenerators - 05032013\01_SourceQVD\DIM_DESIGNATION.qvd]

      (qvd);

       

      Thanks,

      Selva