topic Re: Apply Map Prb in QlikView

Apply Map Prb

Fri, 04 Jul 2014 10:16:13 GMT

Dear All,

Plz find the attachment...

How i can solve this problem...

Plzreply

amit_saini — Fri, 04 Jul 2014 10:21:07 GMT

Rahul,

Go through this attachment.

Thanks,

er_mohit — Fri, 04 Jul 2014 10:26:14 GMT

write applymap this way

ApplyMap('Table1',C) as B

before table closed write

where condition like

Data:

LOAD C,

ApplyMap('Table1',C) as B,

FROM

C:\Users\Administrator\Desktop\Applymap.xlsx

(ooxml, embedded labels, table is Sheet2) where 1=1;

Fri, 04 Jul 2014 10:39:45 GMT

Thanks mohit

But what about Table1 where 1=AA and 2=VV...??

Is Applymap show only first mapping records..?

Fri, 04 Jul 2014 11:53:24 GMT

Hi Rahul,

Hope this will solve your issue...

Data:

LOAD

FROM

[..\Desktop\Applymap.xlsx]

(ooxml, embedded labels, table is Sheet2);

join(Data)

LOAD C,

FROM

[..\Desktop\Applymap.xlsx]

(ooxml, embedded labels, table is Sheet1);