Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_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 |
Table 2:
IR_DPD | FullPOS | POS |
0 - 29 DPD | 631,626,108 | 1 |
30 - 59 DPD | 303,230,518 | 2 |
60 - 89 DPD | 215,404,729 | 3 |
90 - 119 DPD | 203,847,230 | 4 |
120 - 149 DPD | 320,946 | 5 |
180 - 209 DPD | 376,862 | 6 |
240 - 269 DPD | 914,550 | 7 |
390 - 419 DPD | 497,457 | 8 |
Current | 12,394,438,430 | 9 |
Now i want the Table 2 data should join into Table1(using mapping load). and the output i should get is:
IR_DPD | no of Accts | FullPOS | POS |
0 - 29 DPD | 24,443 | 631,626,108 | 1 |
30 - 59 DPD | 11,770 | 303,230,518 | 2 |
60 - 89 DPD | 8,426 | 215,404,729 | 3 |
90 - 119 DPD | 8,001 | 203,847,230 | 4 |
120 - 149 DPD | 1 | 320,946 | 5 |
180 - 209 DPD | 1 | 376,862 | 6 |
240 - 269 DPD | 1 | 914,550 | 7 |
390 - 419 DPD | 2 | 497,457 | 8 |
Current | 317,066 | 12,394,438,430 | 9 |
GWO | 3,938 | - | - |
NCL | 68,928 | - | - |
Thanks
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
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..
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
Its not solving My Problem.. U mean to say that we cant join 2 columns in to one table using Mapping Load.
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...
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
Please Can Any One solve my query???