AWK using two input files

Shell Programming and Scripting
1

Hi ,
i have two input files one is input.gz and another is ( input.txt) text file.in gz format input file each record contains 10 fields and corresponding header value is present in the text file as a single record i.e text file contains only 10 records which is header value,so output of the awk command should contain print field value from first field value from gz file and header value from text file,like that every field value should be associated with its field column name from the text file.

gzcat input.gz|tail -3
aaa,bbb,ccc,ddd,eee,fff,ggg,hhh,jjj,eee
aaa,8888,ccc,ddd,555,fff,ggg,333,jjj,eee
222,8888,aaa,bbb,555,888,ggg,333,jjj,hai

cat input.txt

name
designation
DOB
place
address1
address2
address3
phoneno
emailid
mobileno

I tried with the following command ,i am unable to achieve it.

gzcat  input.gz|nawk -F"," '{for (i=1;i<=NF;i++) print "field no",i,"file value",$i,system("sed -n {$i}p input.txt")}'

Can someone guide me in getting the output.

2

Something like this:

gzcat input.gz | awk '...' input.txt -

This code will read input.txt first and then the input from pipe(gzcat).