Merging two files together Is it possible to merge two files together using awk? I have two files with matched  Chrom and pos  column

file1 has the columns

CHROM   POS ID  REF ALT QUAL    FILTER  INFO


file2 has the columns 

CHROM POS ID REF ALT FATHER MOTHER DAUGHTER1 DAUGHTER2 DAUGHTER3 SON1 SON2


I want the final merged file to have these columns

CHROM   POS ID  REF ALT QUAL    FILTER  INFO FATHER MOTHER DAUGHTER1 DAUGHTER2 DAUGHTER3 SON1 SON2
I'd recommend using R and either merge or one of the joins. Assuming your data is not too large, data.frame + read.delim should suffice to hold the two datasets. If not, try data.table + fread..