Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Want to Solve the Query using Mapping Load

Hi,

Please help my query using Mapping Load instead of using JOIN, as i am not much aware of mapping load

I have 2 table

Table1:

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


Table 2:

IR_DPDFullPOSPOS
0 - 29 DPD631,626,1081
30 - 59 DPD303,230,5182
60 - 89 DPD215,404,7293
90 - 119 DPD203,847,2304
120 - 149 DPD320,9465
180 - 209 DPD376,8626
240 - 269 DPD914,5507
390 - 419 DPD497,4578
Current12,394,438,4309


Now i want the Table 2 data should join into Table1(using mapping load). and the output i should get is:

IR_DPDno of AcctsFullPOSPOS
0 - 29 DPD24,443631,626,1081
30 - 59 DPD11,770303,230,5182
60 - 89 DPD8,426215,404,7293
90 - 119 DPD8,001203,847,2304
120 - 149 DPD1320,9465
180 - 209 DPD1376,8626
240 - 269 DPD1914,5507
390 - 419 DPD2497,4578
Current317,06612,394,438,4309
GWO3,938--
NCL68,928--


Thanks

7 Replies
Not applicable
Author

Hi,

Your load script should be as below.

Table1:

Mapping Load IR_DPD,

"no of Accts"

from Table1;

Table2:

Load IR_DPD,

FullPOS,

POS,

Applymap('Table1',IR_DPD,null()) as "no of Accts"

From Table2;

Hope this will help you.

- Sridhar

Not applicable
Author

Thanks Sridar for the reply..

But this couldnt help me and get the output as i want.. I want from Table 2 there are 2 columns (FullPOS,POS) should jon in to Table 1. Because in table 1 the 1st unique coulmn (IR_DPD) is more then 2nd one..

please help me with other solution..

sunil2288
Creator III
Creator III

HI Ankit

It does n't matter ...just Load the excel sheet and perform the mapping as in the second table



Applymap('Table1',IR_DPD,null()) as "no of Accts"

in the second table as a colomn

cheers,

Regards,

Sunil

Not applicable
Author

Its not solving My Problem.. U mean to say that we cant join 2 columns in to one table using Mapping Load.

sunil2288
Creator III
Creator III

HI Ankit

Am not clear about your doubt.. In accordance with your rquirement that u hav mentioned in the prevoius posts Your table should hav 4 columns and that's the solution i hav post...

Not applicable
Author

HI Sunil,

U can Compare my Output with Your output u will find that the DPD's are repeating (eg. 0-29 DPD,60-89DPD..) and the ( -) are occuring.

See basicaly its solves my problem if i have Table1 as base table and do left join(Table 1) and join table 2 with the base table. but i need to solve using Mapping Load.. So is it possible i can write 2 apply Map for puuting 2 columns (FullPOS, POS) in Table 1..

Hope you got some idea

Not applicable
Author

Please Can Any One solve my query???