Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Plz find the attachment...
How i can solve this problem...
Plzreply
Rahul,
Go through this attachment.
Thanks,
AS
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;
Thanks mohit
But what about Table1 where 1=AA and 2=VV...??
Is Applymap show only first mapping records..?
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);