Apply Map Prb

[#1]

Dear All,

Plz find the attachment...

How i can solve this problem...

Plzreply

[amit_saini]

Rahul,

Go through this attachment.

Thanks,

AS

[er_mohit]

write applymap this way

ApplyMap('Table1',C) as B

before table closed write

where condition  like

Data:

LOAD C,

ApplyMap('Table1',C) as B,

     D,

     E

FROM

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

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

[#4]

Thanks mohit

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

Is Applymap show only first mapping records..?

[#5]

Hi Rahul,

Hope this will solve your issue...

Data:

LOAD

     C,

     D,

     E

FROM

[..\Desktop\Applymap.xlsx]

(ooxml, embedded labels, table is Sheet2);

join(Data)

LOAD C,

  B

FROM

[..\Desktop\Applymap.xlsx]

(ooxml, embedded labels, table is Sheet1);