Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pls Solve my Query using Mapping Load

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_DPDFullPOS
0 - 29 DPD631,626,108
30 - 59 DPD303,230,518
60 - 89 DPD215,404,729
90 - 119 DPD203,847,230
120 - 149 DPD320,946
180 - 209 DPD376,862
240 - 269 DPD914,550
390 - 419 DPD497,457
Current12,394,438,430
GWO94,896,352
NCL1,774,643,985
Total15,620,197,167


Table 2:

IR_DPDno of Accts
0 - 29 DPD24,443
30 - 59 DPD11,770
60 - 89 DPD8,426
90 - 119 DPD8,001
120 - 149 DPD1
180 - 209 DPD1
240 - 269 DPD1
390 - 419 DPD2
Current317,066
GWO3,938
NCL68,928
Total442,577


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

IR_DPDFullPOSno of Accts
0 - 29 DPD631,626,10824,443
30 - 59 DPD303,230,51811,770
60 - 89 DPD215,404,7298,426
90 - 119 DPD203,847,2308,001
120 - 149 DPD320,9461
180 - 209 DPD376,8621
240 - 269 DPD914,5501
390 - 419 DPD497,4572
Current12,394,438,430317,066
GWO94,896,3523,938
NCL1,774,643,98568,928
Total15,620,197,167442,577


PLease any of can suggest me how to solve it.

Thanks.

3 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Thanks Johan.. its working perfectly.. Smile