Shell Programming and Scripting

a
b
c
d
e
f

a
b

a
e

c
d
e
f

a

awk -f join.awk input1 input2 input3 input4 inputx .....

a  4  input1  input2  input3  inputx
b  2  input1  input2  0  0  0
c  2  input1  0  0  input4  0
d  2  input1  0  0  input4  0
e  3  input1  0  input3  input4  0
f  2  input1  0  0  input4  0

$ cat join.awk
{
 totalcnt[$1]++
 if(FILENAME != prevfilename)
  filesc++
 filecnt[filesc,$1]++
 fname[filesc]=prevfilename=FILENAME
}

END {
 for(i in totalcnt)
 {
  printf("%s\t%s",i,totalcnt[i])
  for(j=1;j<=filesc;j++)
  {
   printf("\t%s[%d]",fname[j],filecnt[j,i])
  }
  printf("%s","\n");
 }
}

$ cat join.awk
{
 totalcnt[$1]++
 filesc+=(FNR==1)
 filecnt[filesc,$1]=FILENAME
}
END {
 OFS="\t"
 for(i in totalcnt) {
  $0=""; $1=i; $2=totalcnt[i]
  for(j=1;j<=filesc;j++)
     $(j+2)=filecnt[j,i]?filecnt[j,i]:"0"
  print
 }
}