Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee
ABCD,SSS,EFG,1234,9999,2345,AB,30,1,4,1
ABCD,SSS,EFG,1234,9999,2345,AB,40,2,5,2
ABCD,SSS,EFG,1234,9999,2345,AB,60,3,6,3
ABCD,SSS,EFG,3456,9999,2345,AB,30,1,4,1
ABCD,SSS,EFG,3456,9999,2345,AB,40,2,5,2
ABCD,SSS,EFG,3456,9999,2345,AB,60,3,6,3
ABCD,SSS,EFG,5678,9999,2345,AB,30,1,4,1
ABCD,SSS,EFG,5678,9999,2345,AB,40,2,5,2
ABCD,SSS,EFG,5678,9999,2345,AB,60,3,6,3

SendMobNum,Year,Amount,Gender
1234,2000,30,Male
5678,2001,15,Female
2345,2002,60,Female
4567,2003
8888,2004

Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee,SendMobNum,Year,Amount,Gender
ABCD,SSS,EFG,1234,9999,2345,AB,30,1,4,1,1234,2000,30,Male
ABCD,SSS,EFG,1234,9999,2345,AB,60,3,6,3,1234,2000,60,Female
ABCD,SSS,EFG,5678,9999,2345,AB,30,1,4,1,5678,2001,30,Male
ABCD,SSS,EFG,5678,9999,2345,AB,60,3,6,3,5678,2001,60,Female

awk -F, '
    NR == FNR {send[$1]; amt[$3]; next}
    FNR == 1 || ($4 in send && $8 in amt) { print $0","send[$1] ","send[$2]","amt[$3]","amt[$4]}
' master.csv Input*.csv

SendMobNum,Year(i.e Desc of SendMobNum)
1234,2000
5678,2001
2345,2002
4567,2003
8888,2004

Amount,Gender (i.e Desc of Amount)
30,Male
15,Female
60,Female

Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee
ABCD,SSS,EFG,1234,9999,2345,AB,30,1,4,1

Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee,SendMobNum,Year,Amount,Gender
ABCD,SSS,EFG,1234,9999,2345,AB,30,1,4,1,1234,2000,30,Male

Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee
ABCD,SSS,EFG,1234,9999,2345,AB,15,1,4,1

Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee,SendMobNum,Year,Amount,Gender
ABCD,SSS,EFG,1234,9999,2345,AB,15,1,4,1,1234,2000,15,Female

Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee
ABCD,SSS,EFG,1234,9999,2345,AB,60,1,4,1

Transaction ID,Request source,User name,SendMobNum,RecMobNum,ServiceClass,Service,Amount,CreditAmount,Bonus,Process fee,SendMobNum,Year,Amount,Gender
ABCD,SSS,EFG,1234,9999,2345,AB,60,1,4,1,1234,2000,60,Female