Hi Experts!!!!
Tried a lot but in vein,no success, please help to achieve this
LOGIC behind is first field is reffrance row field, the second field shoud be made titles of coulmn and the the third field is made as matrix value.
And if they dont match the matrix value should be 0. (Unix (Shell, perl, awk, sed, tr or one liner will do).
INPUT FILE:
1000K,MINE,345654
1000K,YOUR,909285
200K,MINE,886049
50K,MINE,277339
50K,YOUR,210002
100K,YOUR,995994
100K,MINE,999996
500K,HIS,656565
200K,HIS,45103
1000K,HER,323232
OUTPUT FILE:
K,MINE,YOUR,HIS,HER
1000K,345654,909285,0,323232
200K,886049,0,45103,0
50K,277339,210002,0,0
100K,999996,995994,0,0
500K,0,0,656565,0
Thanks A lot For interest and solution.
War doesnt determine who is right, it determines who is left.