Apply Map with inline

[#1]

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

[kaushiknsolanki]

Try this.

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) as New_Designation

     FROM

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

(qvd);

Regards,

Kaushik Solanki

[neetu_singh · Accepted solution]

Hi,

Please find the attached file, may be it will help you out.

If not please elaborate your query nd if possible send me the sample file.

Thanks

Neetu

[#4]

Thanks Neethu..

I want exactly the same..

Selva