nawk -F, 'FNR==NR{a[$1]= $3 ;next} $2 in a{print $1, 'Person',$2, a[$2]}' OFS=, filea fileb
Input filea
Input fileb
output i am getting :
nawk -F, 'FNR==NR{a[$1]= $3 ;next} $2 in a{print $1, 'Person',$2, a[$2]}' OFS=, filea fileb
Input filea
Input fileb
output i am getting :
Try this:
awk -F "," 'FNR==NR && NR>1{a[$1]=$3;next}FNR>1{if ($2 in a)print $1,"Person",$2,a[$2]; else print $1,"Person",$2 OFS}' OFS="," filea fileb
cheers,
Devaraj Takhellambam
Thank you sir