Pls Solve my Query using Mapping Load

[#1]

HI,

As ia m new in to Qlikview and using 8.5. i have stuck into a query and want o solve using Mapping Load..

I have 2 tables

Table1:

IR_DPD	FullPOS
0 - 29 DPD	631,626,108
30 - 59 DPD	303,230,518
60 - 89 DPD	215,404,729
90 - 119 DPD	203,847,230
120 - 149 DPD	320,946
180 - 209 DPD	376,862
240 - 269 DPD	914,550
390 - 419 DPD	497,457
Current	12,394,438,430
GWO	94,896,352
NCL	1,774,643,985
Total	15,620,197,167

Table 2:

IR_DPD	no of Accts
0 - 29 DPD	24,443
30 - 59 DPD	11,770
60 - 89 DPD	8,426
90 - 119 DPD	8,001
120 - 149 DPD	1
180 - 209 DPD	1
240 - 269 DPD	1
390 - 419 DPD	2
Current	317,066
GWO	3,938
NCL	68,928
Total	442,577

Now, instead of using JOIN i want to use MAPPING LOAD to get the Output as:

IR_DPD	FullPOS	no of Accts
0 - 29 DPD	631,626,108	24,443
30 - 59 DPD	303,230,518	11,770
60 - 89 DPD	215,404,729	8,426
90 - 119 DPD	203,847,230	8,001
120 - 149 DPD	320,946	1
180 - 209 DPD	376,862	1
240 - 269 DPD	914,550	1
390 - 419 DPD	497,457	2
Current	12,394,438,430	317,066
GWO	94,896,352	3,938
NCL	1,774,643,985	68,928
Total	15,620,197,167	442,577

PLease any of can suggest me how to solve it.

Thanks.

[#2]

I would do it like this:

MapTable:

MAPPING

LOAD


 IR_DPD
,
FullPOS
FROM

Book1.xlsx
(
 ooxml, embedded labels, table is Sheet1)
;
FactTable:

LOAD



 IR_DPD
,
[no of Accts]


,
ApplyMap

 ('MapTable', IR_DPD, Null()) AS
Mapped_FullPos
FROM

Book1.xlsx
(
 ooxml, embedded labels, table is Sheet2)
;

Regards

Johan

[#3]

Excuse me for the failed appempt to include code in the previous post. Here is another attempt:

MapTable:
MAPPING
LOAD IR_DPD,
FullPOS
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);

FactTable:
LOAD IR_DPD,
[no of Accts],
ApplyMap('MapTable', IR_DPD, Null()) AS Mapped_FullPos
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet2);

[#4]

Thanks Johan.. its working perfectly..