topic Apply Map with inline in QlikView

Apply Map with inline

Mon, 01 Apr 2013 06:57:45 GMT

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

Re: Apply Map with inline

kaushiknsolanki — Mon, 01 Apr 2013 07:05:16 GMT

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

Re: Apply Map with inline

neetu_singh — Mon, 01 Apr 2013 07:15:52 GMT

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

Re: Apply Map with inline

Mon, 01 Apr 2013 08:00:56 GMT

Thanks Neethu..

I want exactly the same..

Selva