I have to files
File1
1 23
2 34
3 7
4 56
5 61
6 22
7 65
File2
2 21
4 32
7 22
Now i need to compare column1 of both the files and generate a third file which should contain all the values of 1st column of 1st file and in the second column i need to get the coressponding row vaues of the second file.and other values to be zero.
Output shuld be like this:
1 0
2 21
3 0
4 32
5 0
6 0
7 22