Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can please Some one share a notes on Set Analysis..
Thanks
Ankit
Didn't got what you are saying.
Add the mapping table as suggested above
then load your table which has the data as IR_DPD FullPOS & POS in addition to that add another column to the data and name it as no of Accts and the values in it would be same as in the IR_DPD column
in this case the code above would work
But couldnt get you why don't you just join the two tables - is easier
Hi Ankit,
As Umang said join is the right thing here and i feel it will be the better one ,Since in this scenario Join will results better performance
and second thing like in the above scenario u r performing Join Operation only and there is no use of Mapping at all.......
Regards,
Ajay
HI Ajay,
Thanks for the reply, i know join would be the option,but we were told to use MApping load isntead of Join in the above example so i was not aware of it and not much idea of Mapping so i had requested the code for Mapping load to get the desired output. And want to learn something related to Mapping Load.
Thanks
Ankit
MAP_K:
Mapping LOAD * INLINE [
IR_DPD, no of accounts
0 - 29 DPD, "24,443"
30 - 59 DPD , "11,770"
60 - 89 DPD, "8,426"
90 - 119 DPD , "8,001"
];
P:
LOAD * INLINE [
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
];
Final:
Load IR_DPD,
applymap('MAP_K',IR_DPD) as [no of accounts],
FullPOS,
POS
Resident P;
Drop Table P;
Try the above code,it will definitely work. I have dropped the table because it is creating a synthetic table and we dont need to have table P because its almost the exact copy of final without the field 'no of accounts'.
Thanks a lot it's working....