Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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);
Thanks Johan.. its working perfectly..