topic Pls Solve my Query using Mapping Load in QlikView

Pls Solve my Query using Mapping Load

Sun, 18 Apr 2010 08:06:06 GMT

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.

Pls Solve my Query using Mapping Load

Sun, 18 Apr 2010 11:30:41 GMT

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

Pls Solve my Query using Mapping Load

Sun, 18 Apr 2010 11:32:32 GMT

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);

Pls Solve my Query using Mapping Load

Mon, 19 Apr 2010 06:20:29 GMT

Thanks Johan.. its working perfectly..