Set Analysis

[#1]

Can please Some one share a notes on Set Analysis..

Thanks

Ankit

[#2]

Didn't got what you are saying.

[#3]

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

[spsrk_84]

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

[#5]

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

[#6]

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'.

[#7]

Thanks a lot it's working....