Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

1 Solution

Accepted Solutions
neetu_singh
Contributor III

Re: Apply Map with inline

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

3 Replies

Re: Apply Map with inline

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
Contributor III

Re: Apply Map with inline

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

Not applicable

Re: Apply Map with inline

Thanks Neethu..

I want exactly the same..

Selva

Community Browser