T is:
juan 10
pepe 5
V is:
luis 6
pepe 4
so luis has no daughters on Training, and I want this to appear. Then I use this pipeline from Toni Reverter from CSIRO:
awk '{print $1}' $1 $2 | sort -u | join -a1 - $1 | awk '{print $1, (NF==2?$2:0)}' | join -a1 - $2 | awk '{print $1, $2, (NF==3?$3:0)}'
which gives
putterri:yarp andres$ ./joinToni.sh V T
juan 0 10
luis 6 0
pepe 4 5
No comments:
Post a Comment