File1
2917,`0722,RDF1+TDEV,90(6),33,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
2917,`0781,RDF1+TDEV,100(5),33,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
File2
2917,`0722,RDF1+TDEV,90(6),03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
2917,`0781,RDF1+TDEV,100(5),03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
2917,`03A2,2-way,44,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
2917,`03A6,2-way,44,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
Output needed
2917,`0722,RDF1+TDEV,90(6),33,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
2917,`0781,RDF1+TDEV,100(5),33,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
2917,`03A2,2-way,44,,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
2917,`03A6,2-way,44,,03E:0_12E:0,10000000c96c4af3_10000000c96c6e88,BL_db00p01e
Basically we need to this
compare $7 from 1st file to $6 in 2nd
Append the line if $7 ( file1) = $6 (file2) but $2 (file1) != $2 (file2)
Also add a "," to replace a missing column in file2 to make sure the output file has same columns in all lines -- thx