I have 3 files:
In file1 I've data like this
A,B,C,D,E,F,G 1,2,3,4,5,6,7 7,6,5,4,3,2,1
In file2 I've data like this
A,B,C,D,E,F,G 1,2,3,4,5,5,7 7,6,6,4,3,2,1
In file3 I've only one field i.e A:
A 1 2 7
Now I want to compare file 1 & file2 on column A which is available in file3.
Columns header & number of columns will be same in both files.
Item FILE1 FILE2 1 F=6 F=5 7 C=5 C=6
If there are more columns mismatch
A,B,C,D,E,F,G 1,2,3,4,5,5,7 7,6,5,2,3,2,1 A,B,C,D,E,F,G 1,2,3,1,4,6,7 7,6,6,4,3,2,1
Then output should like this
Item FILE1 FILE2 1 D=4 D=1 E=5 E=4 F=5 F=6 7 C=5 C=6 D=2 D=4
This is sample, Number of column may vary but it always same in both file1 & file2. And due to this its different from previous question.